sql if else 实例

CREATE PROCEDURE TEST_2

@strTO VARCHAR(3)

AS

DECLARE

@strUNIT_NAME VARCHAR(800),

@strSQL VARCHAR(8000),

@Link VARCHAR(1),

@Link1 VARCHAR(1)



SET @strUNIT_NAME=''

SET @strSQL=''

SET @Link=''

SET @Link1=''

 

BEGIN TRANSACTION

IF @strTO<>''

BEGIN

UPDATE UNIT SET UNIT_NAME=REPLACE(UNIT_NAME,'*','') WHERE UNIT_CODE=@strTO

END

ELSE

BEGIN

UPDATE UNIT SET UNIT_NAME=UNIT_NAME+'*' WHERE UNIT_CODE='011'

END