sqlserver 2000 用触发器同步到 sqlserver 2005,OLE DB 提供程序 'SQL
触发器
USE [jeecg]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER trigger [dbo].[tgr_a_insert]on [dbo].[a]for insertasBEGIN SET NOCOUNT ON SET XACT_ABORT ON begin distributed tran SET XACT_ABORT ON declare @name varchar(50); select @name = name from inserted; set @name = @name; insert into [192.168.1.111].jeecg.dbo.a(name) values(@name); commit tran END插入
insert into jeecg.dbo.a(name) values('aaaa')根据网上配置
http://www.cnblogs.com/pato/archive/2010/08/20/1804998.html#3136500
求大神解答 |
免责声明:本内容仅代表回答会员见解不代表天盟观点,请谨慎对待。
版权声明:作者保留权利,不代表天盟立场。
|
|
|
|