–\u6d4b\u8bd5\u73af\u5883SQL 2014<\/p>\n
\u5728MySql\u73af\u5883\uff1a<\/p>\n<\/p>\n
use test ; Create Table Demo(ID int,Name varchar(50))
\u5728\u63a7\u5236\u9762\u677f—\u7ba1\u7406\u5de5\u5177—\u6570\u636e\u6e90(ODBC)—\u7cfb\u7edf DSN<\/p>\n<\/p>\n
–\u6dfb\u52a0<\/p>\n<\/p>\n
–\u4e0b\u4e00\u6b65\uff08\u5b8c\u6210\uff09<\/p>\n<\/p>\n
\u4e0b\u4e00\u6b65(OK)<\/p>\n
\u6b63\u5e38\u663e\u793a\u914d\u7f6e(MySql_Link),\u8bb0\u4f4f\u540d\u79f0<\/p>\n
\u5728SQL Server\u67e5\u8be2\u5206\u6790\u5668\u6216SSMS\u754c\u9762\u64cd\u4f5c<\/p>\n<\/p>\n
\u65b9\u6cd51\uff1a\u4ee5SSMS\u4e3a\u4f8b<\/p>\n
–\u6253\u5f00\u4f01\u4e1a\u7ba1\u7406\u5668—\u670d\u52a1\u5668\u5bf9\u8c61—\u94fe\u63a5\u670d\u52a1\u5668—\u53f3\u5065\uff08\u65b0\u5efa\uff09<\/p>\n<\/p>\n
\u4e0b\u4e00\u6b65\uff0c\u767b\u9646\u4fe1\u606f<\/p>\n<\/p>\n
\u65b9\u6cd52\uff1a\u6216\u5728\u67e5\u8be2\u5206\u6790\u5668\u91cc\u7528\u8bed\u53e5\u521b\u5efa\u94fe\u63a5\u670d\u52a1\u5668<\/p>\n<\/p>\n
USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N\\\\\\’MYSQL\\\\\\’, @srvproduct=N\\\\\\’MySQL\\\\\\’, @provider=N\\\\\\’MSDASQL\\\\\\’, @datasrc=N\\\\\\’MySql_Link\\\\\\’, @catalog=N\\\\\\’test\\\\\\’ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N\\\\\\’MYSQL\\\\\\’,@useself=N\\\\\\’False\\\\\\’,@locallogin=NULL,@rmtuser=N\\\\\\’root\\\\\\’,@rmtpassword=\\\\\\’########\\\\\\’–MySql\u767b\u9646\u8d26\u53f7(root)\u5bc6\u7801<\/p>\n<\/p>\n
\u5728SQL Server\u67e5\u8be2\u5206\u6790\u5668\u6d4b\u8bd5:<\/p>\n<\/p>\n
–\u6d4b\u8bd5 insert OPENQUERY(MySQL,\\\\\\’SELECT * FROM test.Demo\\\\\\’) (ID,Name) values(1,\\\\\\’Roy\\\\\\’) –\u67e5\u8be2 SELECT * FROM OPENQUERY(MySQL,\\\\\\’SELECT * FROM test.Demo\\\\\\’) AS A \/* IDName 1Roy *\/<\/p>\n
\u66f4\u591a\u5173\u4e8e\u4e91\u670d\u52a1\u5668\uff0c\u57df\u540d<\/a><\/span>\u6ce8\u518c\uff0c\u865a\u62df\u4e3b\u673a\u7684\u95ee\u9898\uff0c\u8bf7\u8bbf\u95ee\u57a6\u6d3e\u79d1\u6280<\/a><\/span>\u5b98\u7f51\uff1awww.kenpai.com<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":" –\u6d4b\u8bd5\u73af\u5883SQL 2014\u5728MySql\u73af\u5883\uff1a use test ; Create Table Demo(ID int,Name varch<\/p>\n","protected":false},"author":2,"featured_media":4348,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3322],"tags":[3908],"class_list":["post-5040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ktougao","tag-sql-server--mysql"],"_links":{"self":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts\/5040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/comments?post=5040"}],"version-history":[{"count":0,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts\/5040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/media\/4348"}],"wp:attachment":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/media?parent=5040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/categories?post=5040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/tags?post=5040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}