Go CREATE TRIGGER DepInsertForSync ON Department FOR INSERT AS SET NOCOUNT ON SET XACT_ABORT ON INSERT INTO DD.sync.dbo.HIS_CSYSDEPT values( 'HIS_CSYSDEPTId', 'DEPT_NO', 'DEPT_CNAME', 'DEPT_ENAME' ) SELECT Dep.DepartmentId, Dep.Code, Dep.Name FROM Department Dep INNER JOIN Inserted vir ON vir.DepartmentId = Dep.DepartmentId
Go CREATE TRIGGER DepInsertForSync ON Department FOR INSERT AS SET NOCOUNT ON SET XACT_ABORT ON INSERT INTO DD.sync.dbo.HIS_CSYSDEPT( DEPT_NO, DEPT_CNAME, DEPT_ENAME ) SELECT Dep.DepartmentId, Dep.Code, Dep.Name FROM Department Dep INNER JOIN Inserted vir ON vir.DepartmentId = Dep.DepartmentId
exec sp_addlinkedsrvlogin 'DD','false',null,'sa','hello'
Go
CREATE TRIGGER DepInsertForSync
ON Department
FOR INSERT
AS
SET NOCOUNT ON
SET XACT_ABORT ON
INSERT INTO DD.sync.dbo.HIS_CSYSDEPT
values(
'HIS_CSYSDEPTId',
'DEPT_NO',
'DEPT_CNAME',
'DEPT_ENAME'
)
SELECT
Dep.DepartmentId,
Dep.Code,
Dep.Name
FROM Department Dep
INNER JOIN Inserted vir ON vir.DepartmentId = Dep.DepartmentId
不对吧,你写的意思不就是将
values(
'HIS_CSYSDEPTId',
'DEPT_NO',
'DEPT_CNAME',
'DEPT_ENAME')
作为值写入了吗?我要的是后面的select中的值
exec sp_addlinkedsrvlogin 'DD','false',null,'sa','hello'
Go
CREATE TRIGGER DepInsertForSync
ON Department
FOR INSERT
AS
SET NOCOUNT ON
SET XACT_ABORT ON
INSERT INTO DD.sync.dbo.HIS_CSYSDEPT(
DEPT_NO,
DEPT_CNAME,
DEPT_ENAME
)
SELECT
Dep.DepartmentId,
Dep.Code,
Dep.Name
FROM Department Dep
INNER JOIN Inserted vir ON vir.DepartmentId = Dep.DepartmentId
INSERT INTO DD.sync.dbo.HIS_CSYSDEPT(
HIS_CSYSDEPTId,
DEPT_NO,
DEPT_CNAME,
DEPT_ENAME
)