create trigger dt on a for update as if exists(select 1 from inserted) and exists(select 1 from deleted) if exists(select 1 from inserted where checksum(*) not in(select checksum(*) from deleted)) insert b select a1,a2,a3,a4,a5 from inserted --修改前后记录信息不同时的处理 else return --修改前后信息相同 go
on a
for update
as
if exists(select 1 from inserted) and exists(select 1 from deleted)
if exists(select 1 from inserted where checksum(*) not in(select checksum(*) from deleted))
insert b select a1,a2,a3,a4,a5 from inserted --修改前后记录信息不同时的处理
else
return --修改前后信息相同
go