可以
-------------------------------------------
----这里是一个两库触发的例子
----你的连接已经建立,只需要修改from..即可
-------------------------------------------
create database B
go
use B
go
create table man(a int, b int, c int, d int)
go
--
create database A
go
use A
go
create table man(a int, b int, c int)
create trigger tr_man_delete on man
for delete
as
delete tmpB
from deleted A, B.dbo.man tmpB
where A.a=tmpB.a and A.b=tmpB.b and A.c=tmpB.c
go
create trigger tr_man_insert on man
for insert
as
insert B.dbo.man
select *, 1 from inserted
go
create trigger tr_man_update on man
for update
as
update B.dbo.man tmpB set tmpB.a=inserted.a, tmpB.b=inserted.b, tmpB.c=inserted.c
from inserted, deleted
where tmpB.a=deleted.a and tmpB.b=deleted.b and tmpB.c=deleted.c
go
