34,588
社区成员
发帖
与我相关
我的任务
分享
create database DB1
use DB1
create table tb_a(
sid int primary key ,
sname varchar(20)
)
create database DB2
use DB2
create table tb_b(
sid int primary key,
sname varchar(20)
)
create trigger tri_insert on tb_a for insert
as
begin
insert into tb_a select * from DB2.dbo.tb_b
end --运行成功
insert into tb_a values (2,'name')
select * from db2.dbo.tb_b -- 结果没添加到 DB2的 tb_b 表
insert into tb_b select * from DB1.dbo.tb_a