34,594
社区成员
发帖
与我相关
我的任务
分享
declare @icount int
declare @SrvTableName varchar(10)
select @icount=count(*) from @SrvTableName
exec ('select @icount=COUNT(*)' + 'from ' + @SrvTableName)
输出参数
declare @num int,
@sqls nvarchar(4000)
set @sqls='select count(*) from tableName'
exec(@sqls)
--如何将exec执行结果放入变量中?
方法一:
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
方法二:
declare @num int,
@sqls nvarchar(4000)
set @sqls='select count(*) from newslist '
exec sp_executesql @num=@sqls
print @num