Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL SERVER 2000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨

ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍÓû§ÃûÖ®¼äÊÇÁ½¸öµã£»
ÀýÈç:
select top 10 * from opendatasource('MSDAORA', 'Data Source=HZTEST;User ID=osstest;Password=a1234')..OSSTEST.SUBSCRIBER
±¾µØOracle¿Í»§¶ËÅäÖÃÎļþÖÐÄÚÈÝÈçÏÂ:
HZTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.149.7.19)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)
2. ʹÓÃMS SQLµÄopenrowsetº¯Êý
select A.* from openrowset('MSDAORA','XST4';'manager';'sjpsjsjs', 'MISD.PBCATCOL') as A
order by A.ID
ʹÓÃÕâÖÖ·½Ê½Ò»¶¨ÒªÓñðÃû²ÅÐÐ
3.ʹÓÃODBC·½Ê½
select A.* from openrowset('MSDAORA','XST4_ODBC';'manager';'sjpsjsjs', 'MISD.PBCATCOL') as A order by A.ID
XST4_ODBCÊÇODBCÊý¾ÝÔ´
4.ʹÓÃÁ´½Ó·þÎñÆ÷·½Ê½
EXEC SP_ADDLINKEDSERVER
@server='mylinkedserver', --Á´½Ó·þÎñÆ÷Ãû³Æ
@srvproduct='Oracle', --¹Ì¶¨
@provider='MSDAORA', --¹Ì¶¨
@datasrc='XST4' --Oracle±¾µØ·þÎñÃû
¸ÃÎÄÕÂ×ªÔØ×ÔµÂ×й¤×÷ÊÒ£ºhttp://www.dezai.cn/article_show.asp?ArticleID=17285


Ïà¹ØÎĵµ£º

SQLÓï¾äÓÅ»¯Êµ¼ùÖ®Ò»SQL_TRACE

SQLÓï¾äÓÅ»¯Êµ¼ùÖ®Ò»SQL_TRACE
 
»·¾³£ºÔÚPL/sqlÉϵ÷ÊÔÊý¾Ý
Pl/sql developer¹¤¾ßÁ¬½ÓʵÀýºó¼´×÷Ϊһ¸öÓû§½ø³ÌÕ¼ÓÃÒ»¸ösession£»
 
select * from  v$session t  where t.PROGRAM='plsqldev.exe' and  t.USERNAME='DZJC'
²éѯ½á¹ûÏÔʾÁ˼¸¸ö¹Ø¼üµÄ×Ö¶Î
SADDR   RAW(4)  S ......

SQL Server bcp

D:\projects\openi\misc\xxxx_data_20090828>bcp [xxxxolap].[dbo].[wdb_cxbz]  in wdb_xxx.txt      -c -T
SQLState = 37000, NativeError = 4060
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "xxxolap" requested by the login. The login failed.
S ......

ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì(תÌù)

ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì(תÌù)    
  ----   ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ  
  Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â  
  »·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓ ......

Åú´¦ÀíbatÖ´ÐÐsql½Å±¾

set r=%time%
echo %r%¿ªÊ¼µ¼Èë >>e:\c#\test.txt
osql -S (local) -U sa -P -d colorring -i e:\c#\11.sql >>d:\c#\test.txt
echo %r%µ¼ÈëÍê³É >>e:\c#\test.txt
ÆäÖÐ11.sqlÖÐΪ
bulk insert  colorring..test from 'e:\c#\11.txt'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR ='\n' ......

³¬¼¶ÓÐÓõÄSQLÓï¾ä(·ÖÎöSQL SERVER Êý¾Ý¿â±í½á¹¹×¨ÓÃ)

³¬¼¶ÓÐÓõÄSQLÓï¾ä £¨ÓÃÓÚSQL SERVER ·þÎñÆ÷£©
³¬¼¶ÓÐÓõÄSQLÓï¾ä £¬Ö´Ðк󷵻صÄÁзֱðÊÇ£º±íÃû¡¢ÁÐÃû¡¢ÁÐÀàÐÍ¡¢Áг¤¶È¡¢ÁÐÃèÊö¡¢ÊÇ·ñÖ÷¼ü£¬Óï¾äÈçÏ£º
(·ÖÎöSQL SERVER Êý¾Ý¿â±í½á¹¹×¨ÓÃ)
Select Sysobjects.Name As ±íÃû,
       Syscolumns.Name As ÁÐÃû,
     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ