create table test1(id varchar(4), [name] varchar(5) )
insert test1
select '001', 'aa' union all
select '002', 'bb' union all
select '003', 'cc'
create table test2(id varchar(4), grade varchar(5) )
insert test2
select '001', 56 union all
select '001', 70 union all
select '002', 87
create trigger roy on test1
for update,delete
as
if update(id)
update test2
set id=i.id
from inserted i,deleted d
where d.id=test2.id
delete test2
from test2 inner join deleted d on test2.id=d.id
测试通过,楼主测试一下