CREATE TRIGGER ck_crd1_UTrig ON dbo.ck_crd1 FOR UPDATE ASif exists(Select * from Inserted a inner Join deleted b
on a.dh=b.dh and (a.Locked<>b.Locked or a.modTimes<>b.modTimes))
begin
Update A Set lastupdat=getdate() From ck_crd1 A Inner Join inserted B On A.dh=B.dh
end
on a.dh=b.dh and (a.Locked<>b.Locked or a.modTimes<>b.modTimes))
begin
Update A Set lastupdat=getdate() From ck_crd1 A Inner Join inserted B On A.dh=B.dh
end
--建议改成create trigger ck_crd1_UTrig ON dbo.ck_crd1
for update asif update(Locked) or update(modTimes)
begin
Update A Set lastupdat=getdate()
From ck_crd1 A
Inner Join inserted B On A.dh=B.dh
end
go
--因为触发器中更新的是lastupdat字段,处理没有问题。