sqlÊý¾Ýµ¼Èëµ¼³ö
´ó¼Ò´ò¿ªÕâ¸öÁ´½Ó¿ÉÒÔ¿´µ½ºÜ¶àÊý¾Ý¿âµÄÁ¬½Ó·½·¨¡£http://www.connectionstrings.com
ÕâЩÊý¾Ý¿âÖ®¼äµÄÊý¾Ý½»»»¾ÍÊÇÕâ¸öÌù×ÓËùÒª×ܽáµÄÄÚÈÝ¡£
£¨Ò»£©SQL ServerÖ®¼ä
°ÑÔ¶³ÌÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½±¾µØÊý¾Ý¿â¡£
http://community.csdn.net/Expert/topic/5079/5079649.xml?temp=.7512018
http://community.csdn.net/Expert/topic/5011/5011278.xml?temp=.1658899
http://community.csdn.net/Expert/topic/4982/4982625.xml?temp=.8189966
°ÑA¿âÀïµÄÆäÖм¸¸ö±íºÍÊÓͼµ¼ÈëB¿â
http://community.csdn.net/Expert/topic/5042/5042648.xml?temp=.2556574
sql2005µÄÊý¾Ý¿âµ¼Èësql2000ÖÐ
http://community.csdn.net/Expert/topic/4954/4954820.xml?temp=.3408625
ÔÚSQL2005ÖÐ ÈçºÎµ¼Èë SQL2000ÖеÄAnalysis Service ?
http://community.csdn.net/Expert/topic/4713/4713032.xml?temp=2.752322E-02
Ó¢Îİæsql server2005ÖÐbcpµ¼³öÖÐÎÄÂÒÂëÎÊÌâ
http://community.csdn.net/Expert/topic/5024/5024662.xml?temp=.7404596
ÈçºÎ½«Ò»¸öÓÉSQL±£´æ³öÀ´µÄ*.basÎļþÔÙµ¼»Øµ½SQLÖÐ
http://community.csdn.net/Expert/topic/4944/4944630.xml?temp=.8225672
£¨¶þ£©SQL Server --> Access
½«SQLÊý¾Ýµ¼³öÖÁAccess£¨SQLÓëAccessͬһ̨»úÆ÷ÉÏ£©
http://community.csdn.net/Expert/topic/4919/4919937.xml?temp=.2461359
½«SQLÊý¾Ýµ¼³öÖÁAccess£¨SQLÓëAccess²»ÔÚͬһ̨»úÆ÷ÉÏ£©
http://community.csdn.net/Expert/topic/4906/4906691.xml?temp=.1377222
http://community.csdn.net/Expert/topic/4917/4917015.xml?temp=.7591364
£¨Èý£©Access --> SQL Server
http://faq.csdn.net/FAQUnfurl.aspx?id=214875
ΪʲôaccessÓësqlserver2000µ¼Èëµ¼³öʱ£¬Êý¾Ý¿â½á¹¹±äÁË£¬Ä¬ÈÏÖ÷¼ü£¬×Ô¶¯±àºÅȫûÁË£¿
http://community.csdn.net/Expert/topic/4712/4712570.xml?temp=.3942224
£¨ËÄ£©txt£¨¼Çʱ¾£©--> SQL Server
http://community.csdn.net/Expert/topic/5045/5045602.xml?temp=.0278284
TXTÎļþµ¼ÈëÊý¾Ý¿â³öÏÖÂÒÂë
http://community.csdn.net/Expert/topic/4939/4939026.xml?temp=.4465296
¹ØÓÚÉÏǧ·Ý´óÎı¾´æÈëSqlserver
http://community.csdn.net/Expert/topic/4973/4973969.xml?temp=.4392816
£¨Î壩SQL Server --> txt
http://community.csdn.net/Expert/topic/4906/4906039.xml?temp=.6642267
SQLµ¼³öTXT»òHTMLÇóÖú
Ïà¹ØÎĵµ£º
MS SQLÈëÃÅ»ù´¡:Ë÷ÒýÊÓͼ
ÊÕ²Ø
¡¡
¡¡ÔÚÇ°ÃæÎÒÃÇÒѾÌáµ½¹ýÓйØÊÓͼµÄÏÂÊö¹Ûµã£ºÓÉÓÚÊÓͼ·µ»ØµÄ½á¹û¼¯Óë¾ßÓÐÐÐÁнṹµÄ±íÓÐ×ÅÏàͬµÄ±í¸ñÐÎʽ£¬²¢ÇÒÎÒÃÇ¿ÉÒÔÔÚSQL
Óï¾äÖÐÏñÒýÓñíÄÇÑùÒýÓÃÊÓͼ£¬ËùÒÔÎÒÃdz£°ÑÊÓͼ³ÆÎªÐé±í¡£±ê×¼ÊÓͼµÄ½á¹û¼¯²¢²»ÒÔ ......
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔØµ½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ»µ¥¼Ç¼·Ö½âÔÙ×°Èëµ½± ......
MySQL Date º¯Êý
ÏÂÃæµÄ±í¸ñÁгöÁË MySQL ÖÐ×îÖØÒªµÄÄÚ½¨ÈÕÆÚº¯Êý£º
º¯ÊýÃèÊö
NOW()
·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä
CURDATE()
·µ»Øµ±Ç°µÄÈÕÆÚ
CURTIME()
·µ»Øµ±Ç°µÄʱ¼ä
DATE()
ÌáÈ¡ÈÕÆÚ»òÈÕÆÚ/ʱ¼ä±í´ïʽµÄÈÕÆÚ²¿·Ö
EXTRACT()
·µ»ØÈÕÆÚ/ʱ¼ä°´µÄµ¥¶À²¿·Ö
DATE_ADD()
¸øÈÕÆÚÌí¼ÓÖ¸¶¨µÄʱ¼ä¼ä¸ô
DATE_SUB()
´ÓÈÕÆÚ ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ó¾ä,
&nb ......