参考:CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
FOR INSERT
AS
insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
解决方案 »
- sql server 表导入出问题了\\\\
- 从表中取得最近2次采购价格的语句
- 如何将一个Ntext字段值付值给另外一个Ntext字段值
- sql2008和sql2000的发布订阅问题,求大神解答
- 请问,SQL7升级SQL2000后报ROOLBACK错误。。兼容性?
- SQL里怎么来实现“金钱值”+汉字的查询存储过程?
- 如何将1 2 3 4 5 6显示为01 02 03 04 05 06,急盼在线解决
- sqlexpress使用OPENDATASOURCE的问题
- adodc\datagrid读取13万条记录(210M),从DATAGRID查看记录,到最后很慢,怎办?
- c语言实现对access数据库的查询的代码
- 请教sqlserver2000里如何提高数据统计查询的速度?
- 十万火急,请在线的高手帮一下(在线等待)
FOR INSERT
AS
insert 库B..表名 select * from inserted