create table tb(id int ,name varchar(10), re varchar(10)) insert into tb select 1,'王',''create trigger trigger_tb on tb for update as begin if update(name) update tb set re='已更改' from tb a,inserted b where a.id=b.id endupdate tb set name ='李' where id=1select * from tbid name re 1 李 已更改乱写的
insert into tb select 1,'王',''create trigger trigger_tb on tb
for update
as
begin
if update(name)
update tb set re='已更改' from tb a,inserted b where a.id=b.id
endupdate tb set name ='李' where id=1select * from tbid name re
1 李 已更改乱写的
然后再写update语句