一个 StoredProcedure 中的多个更新语句 [英] Multiple update statements in one StoredProcedure

问题描述

我想知道是否可以在一个存储过程中有多个 Update 语句

I am wondering if it is possible to have multiple Update statements in a store procedure

像这样:

Update Table1 set field1 = @new_value where id = @table1_id

Update Table2 set field2 = @new_value where id = @table2_id

Update Table3 set field3 = @new_value where id = @table3_id

现在我正在单独执行它们，但由于它们仅一起使用，我想知道它们是否可以仅位于一个 SP 中.

Right now I am executing them seperately but as they are only used together I wonder if they could be located in just one SP.

推荐答案

是的，这是可能的:

CREATE PROCEDURE prc_update (@table1_id INT, @table2_id INT, @table3_id INT, @new_value INT)
AS
BEGIN
        UPDATE  Table1
        SET     field1 = @new_value
        WHERE   id = @table1_id

        UPDATE  Table2
        SET     field2 = @new_value
        WHERE   id = @table2_id

        UPDATE  Table3
        SET     field3 = @new_value
        WHERE   id = @table3_id
END

这篇关于一个 StoredProcedure 中的多个更新语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！