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ÇóÖú
Ïà¹ØÎĵµ£º
select c0501 "¶©µ¥±àºÅ",
c0503 "¹©Ó¦É̱àÂë",a0302 "¹©Ó¦ÉÌÃû³Æ",
to_char(c0515,'yyyy.mm.dd') "¶©»õÈÕÆÚ",
to_char(c0516,'yyyy.mm.dd') "Ô¤¶¨½»»õÈÕÆÚ"
from c05,a03 where c0503=a0301 and
&nb ......
MS SQLÈëÃÅ»ù´¡:Ë÷ÒýÊÓͼ
ÊÕ²Ø
¡¡
¡¡ÔÚÇ°ÃæÎÒÃÇÒѾÌáµ½¹ýÓйØÊÓͼµÄÏÂÊö¹Ûµã£ºÓÉÓÚÊÓͼ·µ»ØµÄ½á¹û¼¯Óë¾ßÓÐÐÐÁнṹµÄ±íÓÐ×ÅÏàͬµÄ±í¸ñÐÎʽ£¬²¢ÇÒÎÒÃÇ¿ÉÒÔÔÚSQL
Óï¾äÖÐÏñÒýÓñíÄÇÑùÒýÓÃÊÓͼ£¬ËùÒÔÎÒÃdz£°ÑÊÓͼ³ÆΪÐé±í¡£±ê×¼ÊÓͼµÄ½á¹û¼¯²¢²»ÒÔ ......
½éÉÜ
ÎÒÃÇÒ»ÆðÀ´×ö¸öʾÀý£¬ÔÚ.NETÖÐн¨Ò»¸öÀ࣬²¢ÔÚÕâ¸öÀàÀïн¨Ò»¸ö·½·¨£¬È»ºóÔÚSQL ServerÖе÷ÓÃÕâ¸ö·½·¨¡£°´ÕÕ΢ÈíËùÊö£¬Í¨¹ýËÞÖ÷ Microsoft .NET Framework 2.0 ¹«¹²ÓïÑÔÔËÐпâ (CLR)£¬SQL Server 2005ÏÔÖøµØÔöÇ¿ÁËÊý¾Ý¿â±à³ÌÄ£ÐÍ¡£ ÕâʹµÃ¿ª·¢ÈËÔ±¿ÉÒÔÓÃÈκÎCLRÓïÑÔ£¨ÈçC#¡¢VB.NET»òC++µÈ£©À´Ð´´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ºÍÓ ......
ÔÚWindows 2003 sp1·þÎñÆ÷ÉÏȱʡ°²×° MS SQL Server 2005 ¼òÌåÖÐÎÄÆóÒµ°æ£¬ÔÚÁ¬½Ó·þÎñÆ÷ʱÏÔʾ“²»ÔÊÐíÔ¶³ÌÁ¬½Ó”¡£
¾ßÌåÏÔʾÈçÏ£º(xxxxxsqlΪ·þÎñÆ÷Ãû£¬ÔÚ±¾µØ²Ù×÷)
C:\Documents and Settings\Administrator>sqlcmd -S xxxxxsql
HResult 0x2£¬¼¶±ð 16£¬×´Ì¬ 1
ÃüÃû¹ÜµÀÌṩ³ÌÐò: ÎÞ·¨´ò¿ªÓë SQL Server ......
SQLµ÷ÓÅ Ö® Á¬½Ó·½Ê½
JoinÊÇÒ»ÖÖÊÔͼ½«Á½¸ö±í½áºÏÔÚÒ»ÆðµÄν´Ê£¬Ò»´ÎÖ»ÄÜÁ¬½Ó2¸ö±í£¬±íÁ¬½ÓÒ²¿ÉÒÔ±»³ÆΪ±í¹ØÁª¡£ÔÚºóÃæµÄÐðÊöÖУ¬Ê¹ÓÔrow source”À´´úÌ攱픣¬ÒòΪʹÓÃrow source¸üÑϽ÷һЩ£¬²¢ÇÒ½«²ÎÓëÁ¬½ÓµÄ2¸örow source·Ö±ð³ÆΪrow source1ºÍrow source 2¡£Join¹ý³ÌµÄ¸÷¸ö²½Öè¾³£ÊÇ´®ÐвÙ×÷ ......