{"id":1893,"date":"2011-08-22T17:12:34","date_gmt":"2011-08-22T09:12:34","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=1893"},"modified":"2011-10-06T23:11:07","modified_gmt":"2011-10-06T15:11:07","slug":"sql%e5%bb%ba%e7%ab%8bdb-link%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2011\/08\/22\/sql%e5%bb%ba%e7%ab%8bdb-link%e7%9a%84%e6%96%b9%e6%b3%95\/","title":{"rendered":"[\u8f49\u8cbc]SQL\u5efa\u7acbDB LINK\u7684\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"http:\/\/share.bbs888.tw\/t5-topic\">\u539f\u6587\u7db2\u5740<\/a><\/p>\n<pre lang=\"SQL\">\r\n\r\n--Add DB Link Server\r\nEXEC sp_addlinkedserver\r\n@server = 'F6', --Server Name\r\n@srvproduct = 'MS SQL',\r\n@datasrc = '192.168.1.1' , --Server IP\r\n@provider = 'SQLNCLI'\r\n\r\n--Remove DB Link Server\r\nEXEC sp_dropserver\r\n@server = 'F6' --Server Name\r\n\r\n--Add Login User and Password\r\nEXEC sp_addlinkedsrvlogin\r\n@rmtsrvname = 'F6' , --Server Name\r\n@useself = 'false' ,\r\n@locallogin = NULL ,\r\n@rmtuser = 'sa' , --User\r\n@rmtpassword = 'sasa' --Password\r\n--Add DB Link Server\r\nEXEC sp_addlinkedserver\r\n@server = 'F6', --Server Name\r\n@srvproduct = 'MS SQL',\r\n@datasrc = '192.168.1.1' , --Server IP\r\n@provider = 'SQLNCLI'\r\n\r\n--Remove DB Link Server\r\nEXEC sp_dropserver\r\n@server = 'F6' --Server Name\r\n\r\n--Add Login User and Password\r\nEXEC sp_addlinkedsrvlogin\r\n@rmtsrvname = 'F6' , --Server Name\r\n@useself = 'false' ,\r\n@locallogin = NULL ,\r\n@rmtuser = 'sa' , --User\r\n@rmtpassword = 'sasa' --Password\r\n\r\n--Query DB Link Server\r\nselect * from sys.servers\r\n--Query DB Link Server\r\nselect * from sys.servers\r\n\r\n--Query Login User\r\nselect * from sys.linked_logins\r\n--Query Login User\r\nselect * from sys.linked_logins\r\n\r\n--Query DB Link Data\r\nselect * from [F6].[database].[dbo].[table]\r\n--select * from [server name].[database name].[owner name].[table name]\r\n\r\n--Query DB Link Data\r\nselect * from [F6].[database].[dbo].[table]\r\n--select * from [server name].[database name].[owner name].[table name]\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u539f\u6587\u7db2\u5740 &#8211;Add DB Link Server EXEC sp_addlinkedserver @serv &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2011\/08\/22\/sql%e5%bb%ba%e7%ab%8bdb-link%e7%9a%84%e6%96%b9%e6%b3%95\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">[\u8f49\u8cbc]SQL\u5efa\u7acbDB LINK\u7684\u65b9\u6cd5<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-1893","post","type-post","status-publish","format-standard","hentry","category-sql-server","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=1893"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1893\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=1893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=1893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=1893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}