先用sp_addlinkedserver 连接服务器,触发器代码:... update linkserver.dbname.dbo.tablename set col1=i.col1,...,colN=i.colN from linkserver.dbname.dbo.tablename a,inserted i where a.key=i.key ...
是对的: 先用sp_addlinkedserver 连接服务器,触发器代码:... update linkserver.dbname.dbo.tablename set col1=i.col1,...,colN=i.colN from linkserver.dbname.dbo.tablename a,inserted i where a.key=i.key ...
update linkserver.dbname.dbo.tablename
set col1=i.col1,...,colN=i.colN
from linkserver.dbname.dbo.tablename a,inserted i
where a.key=i.key
...
先用sp_addlinkedserver 连接服务器,触发器代码:...
update linkserver.dbname.dbo.tablename
set col1=i.col1,...,colN=i.colN
from linkserver.dbname.dbo.tablename a,inserted i
where a.key=i.key
...