DECLARE @STRSQL VARCHAR(5000)
DECLARE @DCOUNT INT
SET @STRSQL='SELECT @DCOUNT=COUNT(*) FROM XC_ORDERPRODUCTLIST WHERE X_ParentID=3761 AND X_Branch2SucFlag=1'
EXEC(@STRSQL)
我想给@DCOUNT取值,但是放在字符串里面不能通过
DECLARE @DCOUNT INT
SET @STRSQL='SELECT @DCOUNT=COUNT(*) FROM XC_ORDERPRODUCTLIST WHERE X_ParentID=3761 AND X_Branch2SucFlag=1'
EXEC(@STRSQL)
我想给@DCOUNT取值,但是放在字符串里面不能通过
DECLARE @DCOUNT INT
SELECT @DCOUNT=COUNT(*) FROM XC_ORDERPRODUCTLIST WHERE X_ParentID=3761 AND X_Branch2SucFlag=1
@DCOUNT声明和@DCOUNT附值不在一个作用域
DECLARE @DCOUNT INT
SET @STRSQL='SELECT @DCOUNT=COUNT(*) FROM XC_ORDERPRODUCTLIST WHERE X_ParentID=3761 AND X_Branch2SucFlag=1'
EXEC sp_executesql @STRSQL, N'@DCOUNT INT Output', @DCOUNT Output
Select @DCOUNT
DECLARE @DCOUNT INT
SET @STRSQL= N'SELECT @DCOUNT=COUNT(*) FROM XC_ORDERPRODUCTLIST WHERE X_ParentID=3761 AND X_Branch2SucFlag=1'
EXEC sp_executesql @STRSQL, N'@DCOUNT INT Output', @DCOUNT Output
Select @DCOUNT