在单个过程中更新具有单个参数的多个表

问题描述：

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[^]

在单个过程中更新具有单个参数的多个表

相关推荐