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;

posted @   zfzf1  阅读(451)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示