CREATE TRIGGER [t_1] ON [user0001]
FOR UPDATE
AS
if update(Last_Update) or update(Trans_ID)
print 'nothing'
else
update user0001 set Last_Update = getdate(), Trans_ID = 0
from inserted where user0001.key = inserted.key
FOR UPDATE
AS
if update(Last_Update) or update(Trans_ID)
print 'nothing'
else
update user0001 set Last_Update = getdate(), Trans_ID = 0
from inserted where user0001.key = inserted.key
FOR UPDATE
update user0001 set Last_Update=getdate(),Trans_ID = 0 where 主键 in (select 主键 from inserted)