如何在 SQL Server 通过存储过程 读取 MySQL中的数据?,存储过程mysql
SQL 是2005的. windows 2003.
谢谢.
解决方案
添加链接服务器即可。
EXEC sp_addlinkedserver @server = 'test', @srvproduct='MySQL',
@provider = 'MSDASQL', @datasrc = test
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname='test',@useself='false',@locallogin='sa',@rmtuser='root',@rmtpassword='root'
insert into Sys_online
( areaid, [online], createDate)
(
SELECT '1' as areaid, [online], createDate FROM OPENQUERY (test ,'select online, createDate from t_server_log where createDate between date_sub(current_date(),interval 1 day) and current_date()' )
)
详见:
http://www.cnblogs.com/TomYu/archive/2008/07/18/1245824.html
用户评论