以下语句是错的，怎么办？
DECLARE
@fcount as int --记录数
set @fcount=0
exec ( 'select '+@fcount+ '=count(*) from t_ICItem where fnumber not in (select fnumber from t_ICItem) ')
print 1
我想要执行的结果，记录数是否> 0怎么办？
[解决办法]
DECLARE @fcount as int --记录数
declare @sql nvarchar(4000)
set @sql= 'select @fcount=count(*) from t_ICItem where fnumber not in (select fnumber from t_ICItem) '
exec sp_executesql @sql, N '@fcount int output ', @fcount output
select @fcount
[解决办法]
---直接
select @fcount=count(*) from t_ICItem where fnumber not in (select fnumber from t_ICItem)
---就行，或者用 sp_executesql
