本文介绍了使用sql查询将记录从一台服务器传输到另一台服务器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
SELECT *来自Servername / EitherIP Address.pharma.dbo.general_master WHERE NOT EXISTS（SELECT * FROM Servername / EitherIP Address.pharma1415.dbo.general_master WHERE（Servername / EitherIP Address.pharma.dbo.general_master.gmCode = Servername / EitherIP Address.pharma1415.dbo.general_master.gmCode））
SELECT * from Servername/EitherIP Address.pharma.dbo.general_master WHERE NOT EXISTS(SELECT * FROM Servername/EitherIP Address.pharma1415.dbo.general_master WHERE ( Servername/EitherIP Address.pharma.dbo.general_master.gmCode= Servername/EitherIP Address.pharma1415.dbo.general_master.gmCode))
推荐答案
Insert Into Server1.Database1.dbo.Table1 (Col1, Col2)
Select Col1, Col2 From Server2.Database2.dbo.Table2;
试试..
Try it..
这篇关于使用sql查询将记录从一台服务器传输到另一台服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！