declare @Name nvarchar(50)
declare @sql nvarchar(500)='select top 1 @Name=Name from Ent_Hr_People'
exec sp_executesql @sql,N'@Name nvarchar(50) output',@Name output
select @Name
sql sever 将exec执行结构放入变量中
最新推荐文章于 2023-07-18 11:31:02 发布
declare @Name nvarchar(50)
declare @sql nvarchar(500)='select top 1 @Name=Name from Ent_Hr_People'
exec sp_executesql @sql,N'@Name nvarchar(50) output',@Name output
select @Name