必须声明标量变量 [英] Must declare Scalar Variable

问题描述

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

推荐答案

使用 sp_executesql [ ^ ]：

Use sp_executesql[^]:

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
;

如何在SQL Server中使用 sp_executesql 存储过程时指定输出参数 [ ^ ]

How to specify output parameters when you use the sp_executesql stored procedure in SQL Server [^]

这篇关于必须声明标量变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！