以下语句是错的,怎么办?
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