create trigger testa on AA
for updateupdate BB Set BB.ID-2=T.ID-1,BB.Name-2=T.Name-1
from deleted T ,BB where T.ID-2=BB.ID-1
........
for updateupdate BB Set BB.ID-2=T.ID-1,BB.Name-2=T.Name-1
from deleted T ,BB where T.ID-2=BB.ID-1
........
解决方案 »
- 在SQL Server 2008 R2中SSIS怎么传表名变量?
- 关于 数据库中字符串的拼接
- 创建游标不会做,在线等,谢谢~~~~~~~~~~~~~~~~~~~~~
- 我把内连接的 “字段1=字段2” 改成 “字段1 like '%'+字段2+'%' ”,结果转不出来了,请问我该怎样写这种模糊筛选呢?
- 求助 WHERE (ID > (SELECT MAX(id) FROM (SELECT TOP "&sql_pagesize&" id FROM 中变量无效
- 在线等,查询问题
- 如何解决除法表达式除数为零的情况
- 关于同步配置出错!
- 各位兄台,關于一對多操作
- 添加數據(從一個表到另一個表)
- 初学,如何得到指定时间的记录(sql语句)?
- 想做一个网站所在位置条,怎么取得一个分类的所有父级分类.[多谢多谢]
on AA
for update
as
begin
if exists(select * from AA a,BB b where a.[ID-1]=b.[ID-2])
update a set a.[NAME-2]=b.[NAME-1] from BB a,updated b
where a.[ID-1]=b.[ID-2] if exists(select * from AA a,CC b where a.[ID-1]=b.[ID-3])
update a set a.[NAME-3]=b.[NAME-1] from CC a,updated b
where a.[ID-1]=b.[ID-3] if exists(select * from DD a,BB b where a.[ID-1]=b.[ID-4])
update a set a.[NAME-3]=b.[NAME-1] from DD a,updated b
where a.[ID-1]=b.[ID-4]
endgo
go
insert AA values(1,'aa')
insert AA values(2,'bb')
insert AA values(3,'cc')
gocreate table BB([ID-2] int,[NAME-2] varchar(20))
go
insert BB values(1,'aa')
insert BB values(2,'bb')
insert BB values(3,'cc')
go
create table CC([ID-3] int,[NAME-3] varchar(20))
go
insert CC values(1,'aa')
insert CC values(2,'bb')
insert CC values(3,'cc')
go
create table DD([ID-4] int,[NAME-4] varchar(20))
go
insert DD values(1,'aa')
insert DD values(2,'bb')
insert DD values(3,'cc')
go
--结果
create trigger AA_update
on AA
for update
as
begin
if exists(select * from AA a,BB b where a.[ID-1]=b.[ID-2])
update b set b.[NAME-2]=a.[NAME-1] from AA a,BB b
where a.[ID-1]=b.[ID-2] if exists(select * from AA a,CC b where a.[ID-1]=b.[ID-3])
update b set b.[NAME-3]=a.[NAME-1] from AA a,CC b
where a.[ID-1]=b.[ID-3] if exists(select * from AA a,DD b where a.[ID-1]=b.[ID-4])
update b set b.[NAME-4]=a.[NAME-1] from AA a,DD b
where a.[ID-1]=b.[ID-4]
endgo
--查看
select * from AA
select * from BB
select * from CC
select * from DD
--测试
update AA set [NAME-1]='ee' where [ID-1]=1
--查看
select * from AA
select * from BB
select * from CC
select * from DD
--删除环境
drop table AA
drop table BB
drop table CC
drop table DD
on AA
for update
as
update BB set [NAME-2]=inserted.[NAME-1] from BB,inserted where BB.[ID-2]=inserted.[ID-1]
update CC set [NAME-3]=inserted.[NAME-1] from CC,inserted where CC.[ID-3]=inserted.[ID-1]
update DD set [NAME-4]=inserted.[NAME-1] from DD,inserted where DD.[ID-4]=inserted.[ID-1]
http://community.csdn.net/Expert/topic/4426/4426003.xml?temp=.3137628
像这种的,可以用关系来设置就可以了?
给个例子?