A表和B表都有ID字段可以关联
当更改B表的NAMETYPE字段从0更改成1后
通过匹配两个表的ID字段把A表的TIMETYPE更改成1
如果更新失败则把ID号码记录在CTEMP表中
------解决方案--------------------
create trigger tri_b on b
for update
as
BEGIN
if update(NAMETYPE)
begin
update a set TIMETYPE=1 from a inner join instered as i on a.id=i.id
end
if @@rowcount=0
insert into CTEMP(ID) select id from instered
END