CREATE TRIGGER Tr_adjc_dtl_Update
ON dbo.adjc_dtl
FOR UPDATE
AS
Update Adjc_Dtl Set Revise=Revise+1,Trans_ID=0,Last_Updat=GetDate()
Where exists(Select 1 From Inserted where 主鍵1=Adjc_Dtl.主鍵1 and 鍵2=Adjc_Dtl.主鍵2)
ON dbo.adjc_dtl
FOR UPDATE
AS
Update Adjc_Dtl Set Revise=Revise+1,Trans_ID=0,Last_Updat=GetDate()
Where exists(Select 1 From Inserted where 主鍵1=Adjc_Dtl.主鍵1 and 鍵2=Adjc_Dtl.主鍵2)
create table 表 (a int)
go
insert 表 values (1)
insert 表 values (2)goCREATE TRIGGER 名 ON 表
FOR UPDATE
AS
select a 更新前被删除的数据 from deleted
select a 更新后被插入的数据 from inserted
go
------------测试:
update 表 set a=3