存储过程和触发器要使用链接服务器时要注意的一点
set XACT_ABORT on
if exists(select 1 from sysobjects where name = 'tr_update_pis_ishavepic' and type ='tr')
drop trigger tr_update_pis_ishavepic
GO
create trigger tr_update_pis_ishavepic
on PicRelationship
for insert
AS
set XACT_ABORT on
declare @sysid int
--set @sysid = 3
declare @itemid varchar(20)
select @itemid = CorrelativeItemId,@sysid = RelationSystemId from inserted
if @sysid = 3
update SZDB2.PIS.dbo.tb_brm_estate set ishave_pic = 1 where est_id = @itemid
GO
if exists(select 1 from sysobjects where name = 'tr_update_pis_ishavepic' and type ='tr')
drop trigger tr_update_pis_ishavepic
GO
create trigger tr_update_pis_ishavepic
on PicRelationship
for insert
AS
set XACT_ABORT on
declare @sysid int
--set @sysid = 3
declare @itemid varchar(20)
select @itemid = CorrelativeItemId,@sysid = RelationSystemId from inserted
if @sysid = 3
update SZDB2.PIS.dbo.tb_brm_estate set ishave_pic = 1 where est_id = @itemid
GO