sqlserver调用mysql

执行语句如下:

SELECT * FROM OPENROWSET(
'MSDASQL',
'DRIVER={MySQL ODBC 5.1 Driver};
SERVER=127.0.0.1;
PORT=3306;DATABASE=test;
USER=root;PASSWORD=123456;
STMT=set names gb2312;
OPTION=6049',
'select * from t_user'
)
go

原文地址:https://www.cnblogs.com/wzg0319/p/2613314.html