如何使动态存储过程执行sql语句? [英] How Can i Make a Dynamic stored procedure to execute sql statment ?

问题描述

全部，

我正在使用带有数据类型"TABLE"的参数的动态存储过程.此表包含普通的SQL语句示例插入表名(-)值(-----)，"

我的问题是如何执行表行中的所有这些SQL语句，

任何建议

谢谢，

Hii All,

I am Working In a Dynamic Stored Procedure Which Takes Paramter with DataType "TABLE" .This Table Contains Normal SQL Statments Example " Insert Into Table Name(--) Values(-----),"

My Problem Here Is How Can i Execute All These SQL Statment Which Inside The Table''s Rows,

Any Suggestion

Thanks,

推荐答案

为什么将语句放入TABLE中?

执行多条语句的最简单方法是在一条语句中一次执行所有语句，例如:

Why put the statements inside a TABLE?

Easiest way to execute multiple statements is to execute them all at once in a single statement, like:

BEGIN
 INSERT INTO ....
 INSERT INTO ....
 ...
END

如果您真的想从TABLE执行语句，请使用sp_executesql，这是一个很好的示例:
在存储过程中构建动态SQL [

If you really want to execute statements from a TABLE, use sp_executesql, here is a nice example:
Building Dynamic SQL In a Stored Procedure[^]

Regards
Espen Harlinn

这篇关于如何使动态存储过程执行sql语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！