declare @SQL nvarchar(2000)
DECLARE @tblName nvarchar(50)
DECLARE @totalRec int
set @SQL=N'select @totalRec=count(*) from '+@tblName
EXEC sp_executesql @SQL,
N'@totalRec int',
@totalRec = @totalRec
DECLARE @tblName nvarchar(50)
DECLARE @totalRec int
set @SQL=N'select @totalRec=count(*) from '+@tblName
EXEC sp_executesql @SQL,
N'@totalRec int',
@totalRec = @totalRec
DECLARE @tblName varchar(50)
DECLARE @totalRec int
set @SQL='select @totalRec=count(*) from '+@tblName
exec sp_executesql @sql,N'@totalRec int output',@totalRec output
select @totalRec
[交流]动态SQL语句3: 输出参数
eg:
declare @num,
@sqls
set @sqls='select count(*) from '+@servername+'.a.dbo.b'
exec(@sqls)
我如何能将exec执行的结果存入变量@num中declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from '+@servername+'.a.dbo.b'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
过程需要参数 '@statement' 为 'ntext/nchar/nvarchar' 类型。
DECLARE @tblName varchar(50)
DECLARE @totalRec intset @SQL='select @totalRec=count(*) from '+@tblName
exec sp_executesql @SQL,N'@totalRec int output',@totalRec output