22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER [表E_SamePeriod] ON [dbo].[表E]
FOR INSERT, UPDATE, DELETE
AS
SET XACT_ABORT ON
DELETE FROM 服务器B.数据库D.dbo.表E
INSERT INTO 服务器B.数据库D.dbo.表E
SELECT *
FROM
表E
DELETE FROM 服务器C.数据库D.dbo.表E
INSERT INTO 服务器C.数据库D.dbo.表E
SELECT *
FROM
表E
--动态表 table1
create table table1
(name varchar(20))
insert into table1
select '服务器B' union all
select '服务器C'
CREATE TRIGGER [表E_SamePeriod] ON [dbo].[表E]
FOR INSERT, UPDATE, DELETE
AS
BEGIN
SET XACT_ABORT ON
DECLARE @SQL VARCHAR(8000)
SELECT @SQL=ISNULL(@SQL,'')+'
DELETE FROM ['+NAME+'.数据库D.dbo.表E]
INSERT INTO ['+NAME+'.数据库D.dbo.表E] SELECT * FROM [表E]
'
FROM TABLE1
EXEC(@SQL)
END
GO
CREATE TRIGGER [表E_SamePeriod] ON [dbo].[表E]
FOR INSERT, UPDATE, DELETE
AS
BEGIN
SET XACT_ABORT ON
DECLARE @SQL VARCHAR(8000)
SELECT @SQL=ISNULL(@SQL)+'
DELETE FROM ['+NAME+'.数据库D.dbo.表E]
INSERT INTO ['+NAME+'.数据库D.dbo.表E] SELECT * FROM [表E]
'
FROM TABLE1
EXEC(@SQL)
END
GO