SQL ServerµÄÁ´½Ó·þÎñÆ÷¼¼ÊõС½á
Ò»¡¢Ê¹Óà Microsoft OLE DB Provider For ODBC Á´½ÓMySQL
°²×°MySQLµÄODBCÇý¶¯MyODBC
1¡¢ÎªMySQL½¨Á¢Ò»¸öODBCϵͳÊý¾ÝÔ´£¬ÀýÈ磺ѡÔñÊý¾Ý¿âΪtest ,Êý¾ÝÔ´Ãû³ÆΪ
myDSN
2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC sp_addlinkedserver @server = 'MySQLTest', @srvproduct='MySQL',
@provider = 'MSDASQL', @datasrc = 'myDSN'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname='MySqlTest',@useself='false',@locallogin='sa',@rmtuser='mys
qlµÄÓû§Ãû',@rmtpassword='mysqlµÄÃÜÂë'
3¡¢²éѯÊý¾Ý
SELECT * from OPENQUERY (MySQLTest ,'select * from ±í' )
ÏÂÃæÕâ¸ö²»ÐУº
SELECT * from OPENQUERY (MySQLTest ,'±í' )
×¢Ò⣺²»ÄÜÖ±½ÓÓÃselect * from Á´½Ó·þÎñÆ÷Ãû.Êý¾Ý¿âÃû.Óû§Ãû.±í(»òÊÓͼ)
ËIJ¿·ÖÃû³Æ²éѯÊý¾Ý£¬¿ÉÄÜÊǸöBug.
¶þ¡¢Ê¹Óà Microsoft OLE DB Provider For ORACLE Á´½ÓORACLE
1¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
sp_addlinkedserver '±ðÃû', 'Oracle', 'MSDAORA', '·þÎñÃû'
GO
EXEC sp_addlinkedsrvlogin @rmtsrvname='±ðÃû
',@useself='false',@locallogin='sa',@rmtuser='oracle̞
',@rmtpassword='ÃÜÂë'
2¡¢²éѯÊý¾Ý
SELECT * from ±ðÃû..Óû§Ãû.±í(ÊÓͼ)
×¢Ò⣺ËIJ¿·ÖÃû³ÆÈ«²¿Óôóд
3¡¢Ö´Ðд洢¹ý³Ì
ʹÓÃOPENQUERY:
SELECT *
from OPENQUERY(±ðÃû, 'exec Óû§Ãû.´æ´¢¹ý³ÌÃû')
Èý¡¢ÉèÖÃÁ´½Ó·þÎñÆ÷ÒÔ·ÃÎʸñʽ»¯Îı¾Îļþ
ÓÃÓÚ Jet µÄ Microsoft OLE DB Ìṩ³ÌÐò¿ÉÓÃÓÚ·ÃÎʲ¢²éѯÎı¾Îļþ¡£
ÈôÒªÖ±½Ó´´½¨·ÃÎÊÎı¾ÎļþµÄÁ´½Ó·þÎñÆ÷¶ø²»½«ÎļþÁ´½ÓΪ Access .mdb ÎļþÖÐ
µÄ±í£¬ÇëÖ´ÐÐ sp_addlinkedserver£¬ÈçÏÂÀýËùʾ¡£
Ìṩ³ÌÐòÊÇ Microsoft.Jet.OLEDB.4.0£¬Ìṩ³ÌÐò×Ö·û´®Îª"Text"¡£Êý¾ÝÔ´ÊÇ°ü
º¬Îı¾ÎļþµÄĿ¼µÄÍêÕû·¾¶Ãû³Æ¡£schema.ini Îļþ£¨ÃèÊöÎı¾ÎļþµÄ½á¹¹£©±Ø
ÐëÓë´ËÎı¾Îļþ´æÔÚÓÚÏàͬµÄĿ¼ÖС£Óйش´½¨ schema.ini ÎļþµÄ¸ü¶àÐÅÏ¢£¬
Çë²Î¼û Jet Êý¾Ý¿âÒýÇæÎĵµ¡£
--Create a linked server.
EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'c:\data\distqry',
NULL,
'Text'
GO
--Set up login mappings.
EXEC sp_addlinkedsrvlogin txtsrv, FALSE, NULL, Admin, NULL
GO
--List the tables in the linked server.
EXEC sp_tables_ex txtsrv
GO
--Query one of th
Ïà¹ØÎĵµ£º
SQL²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE ......
1.¶¨Òå»ù±¾±íÓï¾ä
Óï·¨£º
USE Êý¾Ý¿âÃû CREATE TABLE ±íÃû (ÁÐÃû ÀàÐÍ(´óС) DEFAULT'ĬÈÏÖµ',
& ......
µ±Ë÷ÒýËùÔÚÒ³ÃæµÄ»ùÓÚÖ÷¹Ø¼ü×ÖµÄÂ߼˳Ðò£¬ºÍÊý¾ÝÎļþÖеÄÎïÀí˳Ðò²»Æ¥Åäʱ£¬ËéƬ¾Í²úÉúÁË¡£ËùÓеÄÒ¶¼¶Ò³°üº¬ÁËÖ¸ÏòÇ°Ò»¸öºÍºóÒ»¸öÒ³µÄÖ¸Õë¡£ÕâÑù¾ÍÐγÉÒ»¸öË«Á´±í¡£ÀíÏëÇé¿öÏ£¬Êý¾ÝÎļþÖÐÒ³µÄÎïÀí˳Ðò»áºÍÂ߼˳ÐòÆ¥Åä¡£Õû¸ö´ÅÅ̵Ť×÷ÐÔÄÜÔÚÎïÀí˳ÐòÆ¥ÅäÂ߼˳Ðòʱ½«ÏÔÖøÌáÉý¡£¶ÔijЩÌض¨µÄ²éѯ¶øÑÔ£¬Õ⽫´øÀ´¼«¼ÑµÄÐÔÄÜ ......
/* °üº¬CÍ·Îļþ */
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
/* °üº¬SQLCAÍ·Îļþ */
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE sqlda;
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
int money;
......
ת×ÔCSDNÂÛ̳£ºchaihuoniu
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾ ......