冰天雪地,求触发器一个。假设表A id number detail 1 aa asdf 2 bb asdfg 3 er asdfgh表B id2 number2 detail2 5 aa rty 6 aa tyui 7 cc tyuio我想更新A表的number的时候表B的number也跟着一起更新。 求助,谢谢大家。光速结贴。
create trigger tri_A on ta for update as begin if exists (select 1 from deleted a join tb b on a.number=b.number) begin update c set c.number=b.number from deleted a join inserted b on a.id=b.id join tb c on a.number=c.number end end 楼主可以试试
create trigger test on tablename for update update 表B set number....
create trigger triname on dbo.A for update as begin declare @newnum varchar(10) declare @oldnum varchar(10) select @oldnum=number from deleted select @newnum=number from inserted update dbo.B set number2=@newnum where number2=@oldnum end
for update
as
begin
if exists (select 1 from deleted a join tb b on a.number=b.number)
begin
update c set c.number=b.number
from deleted a join inserted b on a.id=b.id join tb c on a.number=c.number
end
end
楼主可以试试
on tablename
for update
update 表B set number....
update
as
begin
declare @newnum varchar(10)
declare @oldnum varchar(10)
select @oldnum=number from deleted
select @newnum=number from inserted
update dbo.B set number2=@newnum where number2=@oldnum
end