exec sp_addlinkedserver 'test ', ' ','SQLOLEDB','58.214.34.132,9046'
exec sp_addlinkedsrvlogin 'test','false',null,'sa','wxsy1234'
select count(1) from test.hongdouHR.dbo.attendance_record where manager_id=253 and att_time='2016/11/1 9:34:00'
exec sp_addlinkedserver 'test ', ' ','SQLOLEDB','58.214.34.132,9046'
exec sp_addlinkedsrvlogin 'test','false',null,'sa','wxsy1234'
select count(1) from test.hongdouHR.dbo.attendance_record where manager_id=253 and att_time='2016/11/1 9:34:00'
转载于:https://www.cnblogs.com/sulong/p/6043438.html