IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'buAdd' AND type = 'TR')
DROP TRIGGER buAdd
GO
CREATE TRIGGER buAdd
ON VEstablishment
FOR INSERT
AS
IF EXISTS (SELECT name FROM master.dbo.sysdatabases
WHERE name = 'GIS')
begin
if exists (select * from gis.dbo.sysobjects
where name = '绿化设施' and type = 'U')
begin
set nocount on
update GIS.GIS.绿化设施 set id = ins.ID
from GIS.GIS.绿化设施 sdebu,inserted ins
where sdebu.编号 = ins.FileNO end
end
GO这个怎么改成分布式触发器 VEstablishment 与 绿化设施 是2台机器上数据库中表,怎改成分布式触发器
WHERE name = 'buAdd' AND type = 'TR')
DROP TRIGGER buAdd
GO
CREATE TRIGGER buAdd
ON VEstablishment
FOR INSERT
AS
IF EXISTS (SELECT name FROM master.dbo.sysdatabases
WHERE name = 'GIS')
begin
if exists (select * from gis.dbo.sysobjects
where name = '绿化设施' and type = 'U')
begin
set nocount on
update GIS.GIS.绿化设施 set id = ins.ID
from GIS.GIS.绿化设施 sdebu,inserted ins
where sdebu.编号 = ins.FileNO end
end
GO这个怎么改成分布式触发器 VEstablishment 与 绿化设施 是2台机器上数据库中表,怎改成分布式触发器
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货