34,838
社区成员




exec sp_addlinkedserver 'DD', '', 'SQLOLEDB','192.168.11.234'
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(--错误在此
'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
exec sp_addlinkedserver 'DD', '', 'SQLOLEDB','192.168.11.234'
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
exec sp_addlinkedserver 'DD', '', 'SQLOLEDB','192.168.11.234'
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
values(
'HIS_CSYSDEPTId',
'DEPT_NO',
'DEPT_CNAME',
'DEPT_ENAME')
作为值写入了吗?我要的是后面的select中的值