DECLARE
@fcount as int --记录数
set @fcount=0
exec ( 'select '[email protected]+ '=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