用于更新查询的存储过程参数 [英] Stored procedure parameter for update queries

问题描述

我可以将表名和列名作为变量传递到存储过程中，然后执行SQL语句:
更新tableName set columnName =''''; ?

Can I pass a Table name aa column name as variables into a stored procedure, that would then do an SQL statement :
Update tableName set columnName='''' ; ?

推荐答案

是的.在存储过程中使用Exec sql查询.

1.创建一个存储过程
2.将输入参数保留为"@TableName"& "@ColumnName"
3.在SP内创建 dynamic sql语句
4.创建一个名为"@dynamicSQL"的参数作为字符串.
5.设置@dynamicSQL ="从"+ @ TableName"中选择"+ @ ColumnName +".
6.现在执行动态sql:Exec @dynamicSQL

试试吧！

Yes you can. Using Exec sql query in a Stored Procedure.

1. Create a stored procedure
2. Keep an input parameter to it as "@TableName" & "@ColumnName"
3. Create a dynamic sql statement inside your SP
4. Create a parameter named "@dynamicSQL" as a string.
5. Set @dynamicSQL = ''Select ''+@ColumnName+'' from ''+@TableName.
6. Now execute the dynamic sql: Exec @dynamicSQL

Try!

这篇关于用于更新查询的存储过程参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！