CREATE TRIGGER TG_DELB ON B FOR DELETE AS BEGIN UPDATE A SET 数量 = 数量 - 1 FROM DELETED INNER JOIN A ON DELETED.编号 = A.编号 IF @@ERROR <> 0 BEGIN ROLLBACK TRAN RAISERROR('有错误发生,删除失败', 16, 1) END END
Create Trigger DelBt On B For Delete As Begin update a set 数量=数量- 1 where 编号=Deleted.编号 if @@Error <> 0 Begin Rollback Tran End End 哈哈,我也是刚学这些!不知对不?
AS
BEGIN
UPDATE A SET 数量 = 数量 - 1
FROM DELETED INNER JOIN A ON DELETED.编号 = A.编号
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
RAISERROR('有错误发生,删除失败', 16, 1)
END
END
As
Begin update a set 数量=数量- 1 where 编号=Deleted.编号
if @@Error <> 0
Begin
Rollback Tran
End
End
哈哈,我也是刚学这些!不知对不?