34,576
社区成员
发帖
与我相关
我的任务
分享做一个UPDATE类的同步更新的例子
A表和B表是2个结构完全一样的表,现在当向A表中某个数据更新时B表中也更新同样的内容.怎么做这样一个触发器哦！谢谢哦！
...全文
请发表友善的回复…
发表回复
windyghronger 2006-10-25
- 打赏
- 举报
存储过程怎么写啊！谢谢啊！
Well 2006-10-24
- 打赏
- 举报
不过最好写个存储过程
Well 2006-10-24
- 打赏
- 举报
create trigger tr_a_update
on a
for update
as
update
b
set
col1=i.col1,
col2=i.col2,
....
from
inseted a inner join b on a.id=b.id
go
on a
for update
as
update
b
set
col1=i.col1,
col2=i.col2,
....
from
inseted a inner join b on a.id=b.id
go
dulei115 2006-10-24
- 打赏
- 举报
create trigger testtrig on tableA for insert,update,delete
as
begin
delete a from tableB a join deleted b on a.Key = b.Key
insert into tableB select * from inserted
end
as
begin
delete a from tableB a join deleted b on a.Key = b.Key
insert into tableB select * from inserted
end
i9988 2006-10-24
- 打赏
- 举报
create trigger tr_a_update
on a
for update
as
update
b
set
col1=i.col1,
col2=i.col2,
....
from
inseted i,
deleted d,
b
where
i.pk=d.pk
and
d.pk=b.pk
go
on a
for update
as
update
b
set
col1=i.col1,
col2=i.col2,
....
from
inseted i,
deleted d,
b
where
i.pk=d.pk
and
d.pk=b.pk
go
