sqlserver dblink

dblink模板

exec sp_addlinkedserver 'ITSV' , '' , 'SQLOLEDB' , '服务器ip'

exec sp_addlinkedsrvlogin 'ITSV' , 'false' , null , '用户名' , '密码'

 

exec sp_addlinkedserver 'ITSV' , '' , 'SQLOLEDB' , '172.16.254.10'

exec sp_addlinkedsrvlogin 'ITSV' , 'false' , null , 'zbtmstoad0511' , 'ycmic20170511_*# @#'

drop table t_ygzl_test;

 

//ITSV.实例名.dbo.表名/视图名

select * from ITSV.yccenter.dbo.view_ygzl;
select * into t_ygzl_test from ITSV.yccenter.dbo.view_ygzl;