如何在单个存储过程中更新和删除多个数据 [英] How Can update and delete multiple data in single Stored Procedure

问题描述

如何在单个存储过程中更新和删除多个数据

How Can update and delete multiple data in single Stored Procedure

推荐答案

CREATE PROCEDURE MyProc
(
@Param1 int,
@Param2 varchar(100)
)
AS
BEGIN

    INSERT INTO Table1 (Col1, Col2)
    VALUES @Param1, @Param2

    UPDATE Table2
    SET Col2 = @Param2 
    WHERE Col1 = @Param1

END

您的要求对我来说不是很清楚，可能是我们大多数人.
通常，在存储过程中，您可以编写多个

Your Requirement is not very clear to me may be most of us.
Generally in a stored procedure you can write multiple

select,insert,Update Query.

作为参考，请检查

For your reference check this

这篇关于如何在单个存储过程中更新和删除多个数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！