CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert db2..tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
FOR INSERT
AS
insert db2..tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
解决方案 »
- 求格式化SQL查询结果
- 网络数据库与应用考试题,急求答案
- 如何分组排序后取序号!
- 如何update表里id最大的一条记录(只用一条语句),次大的呢
- sql 分组后取每组按时间排序的前三条记录写法在前台分页速度慢
- 急救,INSERT语句问题。在线等
- 请教各位,这图应该如何用sqlserver分析及建库?
- 在一个表中有很N个班级(N未知),我需要汇总每个班级总人数,以及每个班状态不为休学学生的总成绩,用一条SQL语句写,该怎么办?
- 在ADO中,如何将SQLServer数据表链接到Access数据库中(注:不通过ODBC)
- CTE 递归算法能进行字符串合并吗?
- 大力邹建我又来请教您俩了
- 恳请大力进来
FOR delete,insert
AS
insert db2..tabSlave select * from inserted
delete db2..tabSlave where 编号 in (select 编号 from deleted)