使用sql查询将记录从一台服务器传输到另一台服务器

本文介绍了使用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))

推荐答案

如果两个服务器在SQL Server中设置为链接服务器 If the two servers are set up as Linked Servers in SQL Server Insert Into Server1.Database1.dbo.Table1 (Col1, Col2) Select Col1, Col2 From Server2.Database2.dbo.Table2;

试试..

Try it..