从数据库A的表中插入到当前数据库的同样表中,条件是A数据库表有记录,而当前没有
大家看,下面这句有什么问题,SQL提示:对象名 ztjpos.dbo.tbhyda 无效
exec sp_addlinkedserver 'srv_lnk ', ' ', 'SQLOLEDB ',A
exec sp_addlinkedsrvlogin 'srv_lnk ', 'false ',null, 'sa ', ' '
insert into tbhyda
select * from OPENQUERY(srv_lnk, 'SELECT * FROM ztjpos.dbo.tbhyda ')
where f_hykh not in(select f_hykh from tbhyda)
exec sp_dropserver 'srv_lnk ', 'droplogins '
[解决办法]
INSERT INTO B SELECT DISTINCT A.* FROM A INNER JOIN B ON CAST(ISNULL(A.COL1, '| ') AS VARCHAR)+CAST(ISNULL(A.COL2 '| ') AS VARCHAR)+CAST(ISNULL(A.COL3 '| ') AS VARCHAR) <> CAST(ISNULL
(B.COL1, '| ') AS VARCHAR)+CAST(ISNULL(B.COL2 '| ') AS VARCHAR)+CAST(ISNULL(B.COL3 '| ') AS VARCHAR)
