本文介绍了必须声明标量变量的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Declare @Nameas varchar
Declare @address as Varchar
Exec('select @Name=Name,@address=Address from Employee where empid=12 ')
i需要在Exec中写入此查询.pls帮助我
i need to write this query inside "Exec" .pls help me
推荐答案
DECLARE @Name as varchar(50);
DECLARE @Address as varchar(50);
EXEC sp_executesql
N'SELECT @Name = Name, @Address = Address FROM Employee WHERE empid = 12',
N'@Name varchar(50) OUTPUT, @Address varchar(50) OUTPUT',
@Name = @Name OUTPUT,
@Address = @Address OUTPUT
;
[]
How to specify output parameters when you use the sp_executesql
stored procedure in SQL Server [^]
这篇关于必须声明标量变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!