触发器
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')根据网上配置
天盟APP下载
