DECLARE @SQLSTR VARCHAR(50),
@SIGN VARCHAR(10),
@ITEMCOUNT INT
--SET @SIGN = '@ITEMCOUNT'
SET @SQLSTR = 'SELECT @SIGN = COUNT(*) FROM TABLENAME where sPhoneNO='+@???
exec sp_executesql @sqlstr,N'@sign int output',@sign=@itemcount
@SIGN VARCHAR(10),
@ITEMCOUNT INT
--SET @SIGN = '@ITEMCOUNT'
SET @SQLSTR = 'SELECT @SIGN = COUNT(*) FROM TABLENAME where sPhoneNO='+@???
exec sp_executesql @sqlstr,N'@sign int output',@sign=@itemcount
@ITEMCOUNT INT
SET @SQLSTR = N'SELECT @X = COUNT(sPhoneNO) FROM TABLENAME'exec sp_executesql @SQLSTR, N'@X int output', @ITEMCOUNT output
SET @SQLSTR = 'SELECT @SIGN = COUNT(*) FROM TABLENAME where sPhoneNO='''+@???+''''
>>是要统计其他表中的行数,请问怎么解决?update Ta
set F1=(select count(*) from Tb where Tb.Fx=Ta.Fx)
from Ta
where ...
可以看看
http://www.csdn.net/expert/topic/783/783714.xml?temp=.675976