CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update tabSlave set 列=aa.列 from inserted aa where aa.编号=tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete tabSlave where 编号 in (select 编号 from deleted)
FOR INSERT
AS
insert tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update tabSlave set 列=aa.列 from inserted aa where aa.编号=tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete tabSlave where 编号 in (select 编号 from deleted)
解决方案 »
- 为什么总是接收不到返回的值
- SQL插入时间数据
- SSIS问题,新建的包在VS能调试通过,但运行出错
- 这个sql怎么写呀。。!!
- 急,求解一个表连接查询的问题
- sql 数据库和C#问题
- oracle语句可以和sql server200通用吗,有些oracle语句在sql server中好象不好用?
- 请问如何在SELECT的时候显示一个表里没有的列?
- 怎样合并两个表???
- SQL1 运行就出现错误,SQL2运行就不出现错误,但在表记录中 testColumn 有些值是包含有 'xx检测xxx' 内容的!
- 使用openrowset 查询无错 , 插入时报错 !!! 另外链接服务器的配置 -安全 标签各是什么意思 ???
- sql 语句错误 , 实现 wu1 ,wu2 ...
for insert,update,delete
as
....
同步修改B表create trigger tname1 on B
for insert,update,delete
as
....
同步修改A表
--创建同步的触发器
create trigger t_test on 表A
for insert,update,delete
as
delete from 表B where id in(select id from deleted)
insert into 表B select * from inserted
go