22,207
社区成员
发帖
与我相关
我的任务
分享
--要定义两个临时变量接收a表中的值,假设a有两个字段分别是id和name
declare @id int,@name varchar(100)
select @id=id,@name=name from a where id=100
--再利用得到的@id和@name执行你后面的操作
select * from b where id
in(select id from a where id>4)
declare @num int, @sqls nvarchar(4000)
set @sqls='select count(*) from tableName'
exec(@sqls)
输出参数
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