在T-SQL语句中访问远程数据库，实现两台数据库之间访问

–两台机器各自建立相应的连接.

–不同服务器数据库之间的数据操作

–创建链接服务器
–exec sp_addlinkedserver ‘服务器2的数据库别名’, ’ ', ‘SQLOLEDB’, ‘服务器2的IP地址’
exec sp_addlinkedserver ‘WBDB’, ’ ', ‘SQLOLEDB’, ‘10.10.1.3’ ;
–exec sp_addlinkedsrvlogin ‘WBDB’, ‘false’,null, ‘sa’, ‘sa密码’ ;
exec sp_addlinkedsrvlogin ‘WBDB’, ‘false’,null, ‘sa’, ‘123456’ ;

–查询示例
select TOP (1000)* from WBDB.CMTWeight.dbo.T_Standard ;

–导入示例
select * into TCMTWeight from WBDB.CMTWeight.dbo.T_Standard where f_endTime>=‘2020-03-13 04:42:37’ ;
insert into
TCMTWeight([F_ID],[F_StdNo],[F_CarNo],[F_ProName],[F_Model],[F_UnitFrom]
,[F_Load],[F_UnitTo],[F_UnLoad],[F_Transport],[F_Driver],[F_Memo],[F_Number],[F_Type],[F_BanCi]
,[F_Gross],[F_Tare],[F_Net],[F_Deduct],[F_Fact],[F_Deduct2],[F_Fact2],[F_SettWgt],[F_Price]
,[F_Money],[F_Price2],[F_Money2],[F_SumMoney],[F_CardID],[F_Unit],[F_GrossTime]
,[F_TareTime],[F_BeginTime],[F_EndTime],[F_CNTime],[F_opManGross]
,[F_opManTare],[F_opMan],[F_edMan],[F_edTime],[F_RePrint],[F_PrTimes],[F_PrMan],[F_PrTime],[F_PrScaleName]
,[F_ScaleNameGross],[F_ScaleNameTare],[F_ScaleNameNet],[F_IsCancel],[F_IsFinish],[F_CanUpdate]
,[F_IsUpdate],[F_DisEdit],[F_MacNo],[F_Status],[F_SerialNo],[F_SerialNoDay],[F_SerialNoMonth]
,[F_SerialNoYear],[F_WgtType],[F_YLStr01],[F_YLStr02],[F_YLStr03],[F_YLStr04],[F_YLStr05],[F_YLStr06]
,[F_YLStr07],[F_YLStr08],[F_YLStr09],[F_YLStr10],[F_YLFlt01],[F_YLFlt02],[F_YLFlt03],[F_YLFlt04]
,[F_YLFlt05],[F_YLFlt06],[F_YLFlt07],[F_YLFlt08],[F_YLFlt09],[F_YLFlt10],[F_YLInt01],[F_YLInt02]
,[F_YLInt03],[F_YLInt04],[F_YLInt05],[FNo]) select * from WBDB.CMTWeight.dbo.T_Standard b where f_endTime>=‘2020-03-13 04:42:37’ and b.f_id not in (select f_id from TCMTWeight)

select * from TCMTWeight;
–delete from TCMTWeight;

–以后不再使用时删除链接服务器
–exec sp_dropserver ‘WBDB’, ‘droplogins’ ;