可以的,把数据库的名称记得下上,比如 insert into dbname.dbo.tbname(a) select 'a'
单库没有触发器insert into tbsada(cp,nno,na1,fa,ty,unit,type,posi,ckamount,oprc,oprct,iprj,iprc,paper,gno,gname,per,xno,tno,cxnno,pnno,pna1,pty,pfa,kcamount,outdate,depotno,kcid,dc,dscp,dpm) values ('急件','46930-SM4-003*','离合器分泵[JAP]','','CB3/CB7/CD#','','销售','',1.0000,70.0000,70.0000,0.0000,25.0000,'XS13000020','','','系统管理员',0.0000,0.0000,'','46930-SM4-003*','离合器分泵[JAP]','CB3/CB7/CD#','',0.0000,'2013.10.23','',80061.0000,'','本田','A')这条记录 插入到A.dbo.tbsada 触发器实现 同时插入b.dbo.isto 咋写了
大概是这样,我这里假设你有个自增列叫ID DECLARE @id int insert into tbsada(cp,nno,na1,fa,ty,unit,type,posi,ckamount,oprc,oprct,iprj,iprc,paper,gno,gname,per,xno,tno,cxnno,pnno,pna1,pty,pfa,kcamount,outdate,depotno,kcid,dc,dscp,dpm) values ('急件','46930-SM4-003*','离合器分泵[JAP]','','CB3/CB7/CD#','','销售','',1.0000,70.0000,70.0000,0.0000,25.0000,'XS13000020','','','系统管理员',0.0000,0.0000,'','46930-SM4-003*','离合器分泵[JAP]','CB3/CB7/CD#','',0.0000,'2013.10.23','',80061.0000,'','本田','A') SET @id=@@identity INSERT INTO B..isto SELECT * FROM tbsada WHERE id=@id
同一个数据库,可以。 不同的数据库,如果可以linked server,也可以。
create trigger dbo.tri_tbsada_isto on A.dbo.tbsada for insert asinsert into b.dbo.isto select * from insertedgo
DECLARE @id int
insert into tbsada(cp,nno,na1,fa,ty,unit,type,posi,ckamount,oprc,oprct,iprj,iprc,paper,gno,gname,per,xno,tno,cxnno,pnno,pna1,pty,pfa,kcamount,outdate,depotno,kcid,dc,dscp,dpm)
values ('急件','46930-SM4-003*','离合器分泵[JAP]','','CB3/CB7/CD#','','销售','',1.0000,70.0000,70.0000,0.0000,25.0000,'XS13000020','','','系统管理员',0.0000,0.0000,'','46930-SM4-003*','离合器分泵[JAP]','CB3/CB7/CD#','',0.0000,'2013.10.23','',80061.0000,'','本田','A')
SET @id=@@identity
INSERT INTO B..isto
SELECT *
FROM tbsada
WHERE id=@id
不同的数据库,如果可以linked server,也可以。
create trigger dbo.tri_tbsada_isto
on A.dbo.tbsada
for insert
asinsert into b.dbo.isto
select *
from insertedgo