我写如下存储过程,想获得执行sql语句的返回值,但编译无法通过,请高手帮忙!
DECLARE @RTN INT
EXEC SP_ADDLINKEDSERVER 'SRV_NN','','SQLOLEDB','192.168.1.118'
EXEC SP_ADDLINKEDSRVLOGIN 'SRV_NN','FALSE',NULL,'SA','MANAGER'
@RNT = EXEC('UPDATE SRV_NN.TTCLXT.DBO.T_ORDERDETAIL SET PORDERNO=NULL')
IF @RTN = 1
/*如果成功,执行相应代码*/
ELSE
/*如果失败,执行相应代码*/ EXEC SP_DROPSERVER 'SRV_NN','DROPLOGINS'
DECLARE @RTN INT
EXEC SP_ADDLINKEDSERVER 'SRV_NN','','SQLOLEDB','192.168.1.118'
EXEC SP_ADDLINKEDSRVLOGIN 'SRV_NN','FALSE',NULL,'SA','MANAGER'
@RNT = EXEC('UPDATE SRV_NN.TTCLXT.DBO.T_ORDERDETAIL SET PORDERNO=NULL')
IF @RTN = 1
/*如果成功,执行相应代码*/
ELSE
/*如果失败,执行相应代码*/ EXEC SP_DROPSERVER 'SRV_NN','DROPLOGINS'
EXEC SP_ADDLINKEDSRVLOGIN 'SRV_NN','FALSE',NULL,'SA','MANAGER'
UPDATE SRV_NN.TTCLXT.DBO.T_ORDERDETAIL SET PORDERNO=NULL
IF @@error =0
/*如果成功,执行相应代码*/
ELSE
/*如果失败,执行相应代码*/ EXEC SP_DROPSERVER 'SRV_NN','DROPLOGINS'