在单个过程中更新具有单个参数的多个表 [英] Update Multiple Table with Single Parramete in single procdure

问题描述

Create  PROCEDURE DeleteRecycleAssignmentGiven      
       
@Given_Id  int             
                
AS             
 SET NOCOUNT ON             
 SET XACT_ABORT ON              
             
 BEGIN TRAN          
         
         
 UPDATE    dbo.S_Assignment_Given_Master
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

 UPDATE    dbo.S_Assignment_Given_Child
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

 UPDATE    dbo.Batch_Assignment_Mst
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

COMMIT

当我更新....这个程序可以在所有3表中进行更新吗？这个程序对吗？

when i update.... Can this procdure make update in All 3 Table? this procdure right?

推荐答案

答案是： YES 和 NO 。这取决于很多因素：

1）表之间是否存在关系（PK-FK）？

2）是否启用了级联更新： ON UPDATE CASCADE ？



请参考以下内容：

创建表（Transact-SQL） [ ^ ]

级联参照完整性约束 [ ^ ]

The answer is: YES and NO. It depends of many factors:
1) Does tables have relationship between them (PK-FK)?
2) Does cascading updation is enabled: ON UPDATE CASCADE?

Please, refer these:
CREATE TABLE (Transact-SQL)[^]
Cascading Referential Integrity Constraints[^]

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