什么是SQL服务器等效于Oracle中的EXECUTE IMMEDIATE INTO [英] What is the SQL server equivalent of EXECUTE IMMEDIATE INTO in Oracle
问题描述
什么是SQL服务器相当于Oracle中的EXECUTE IMMEDIATE INTO
What is the SQL server equivalent of EXECUTE IMMEDIATE INTO in Oracle
Eg
DECLARE
DECLARE
QRY varchar(100);
QRY varchar(100);
val int;
val int;
BEGIN
BEGIN
QRY:='select count(*)from production.product';
QRY:='select count(*) from production.product';
EXECUTE IMMEDIATE QRY into val;
EXECUTE IMMEDIATE QRY into val;
dbms_output.put_line(val);
dbms_output.put_line(val);
END;
END;
/
推荐答案
嗨Sangram,
Hi Sangram,
这个是动态SQL,可以找到其他信息: 如何构建和执行动态SQL查询?
This is Dynamic SQL and additional information can be found: How to build and execute dynamic SQL queries?
您还可以利用 EXECUTE(Transact-SQL) 与EXEC IMMEDIATE基本相同(或非常相似)。
You can also leverage EXECUTE (Transact-SQL) which is essentially the same (or very similar) as EXEC IMMEDIATE.
"即使经常使用exec调用存储过程,您也可以使用它来执行变量字符串,这样您就能够以与在Oracle中相同的方式构造变量字符串。"
"Even when exec is used regularly to invoke stored procedures, you can also use it to execute a variable string in this way you'll be able to construct in the same manner as you do in Oracle."
我希望这有帮助!
这篇关于什么是SQL服务器等效于Oracle中的EXECUTE IMMEDIATE INTO的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!