--最好有主键或者唯一索引,否则,数据行没法对应,我这里假设你有个id字段是主键create trigger tr_a_update_insert
on a
for update,inserted
asupdate a set
guding=case when a.guding is null or guding='1900-1-1' then getdate() else a.guding end,
huodong=getdate()
from a,inserted i
where a.id=i.idgo
on a
for update,inserted
asupdate a set
guding=case when a.guding is null or guding='1900-1-1' then getdate() else a.guding end,
huodong=getdate()
from a,inserted i
where a.id=i.idgo
update 表A
set ...,guding = (case when guding is null then getdate() else guding end),
huodong = getdate()
你就在set后边多加guding = (case when guding is null then getdate() else guding end),
huodong = getdate()