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

Sql Server 2005 ÖеÄͬÒå´ÊÓë¸´ÖÆ

ÔÚ2005ÖÐÓÐͬÒå´ÊÓë¸´ÖÆµÄ¸ÅÄî
ͬÒå´ÊµÄÖ÷Òª×÷ÓÃÊÇ£º
        Ò»£ºË޶̶ÔÏóµÄÃû³Æ£¬¼õÉÙ¹¤×÷ÈËÔ±ÊéдµÄʱ¼ä£¬Ìá¸ßЧÂÊ¡£ÎÒÃÇÖªµÀ·ÃÎÊÊý¾Ý¿âÒ»¸ö¶ÔÏóµÄͨ³£×îÈ«µÄ¶ÔÏóÃû³ÆÊÇ£º·þÎñÆ÷Ãû³Æ¡£Êý¾Ý¿âÃû³Æ¡£¼Ü¹¹Ãû³Æ¡£¶ÔÏóÃû³Æ
        ¶þ£ºÍ¬²½Êý¾Ý¡£¿ÉÒÔ½«ÆäËüÊý¾Ý¿âµÄ¶ÔÏóÉõÖÁÊÇÔ¶³ÌÊý¾Ý¿âÖеĶÔÏóÓ³Éäµ½µ±Ç°µÄÊý¾Ý¿â£¬´Ó¶ø´ïµ½ÁËͬ²½Êý¾ÝµÄ×÷ÓÃ
¸´ÖƵÄÖ÷Òª×÷ÓÃÊÇ£º
        Ò»£ºÍ¬²½Êý¾Ý
           ¸´ÖÆÊÇÒ»×é¼¼Êõ£¬Ëü½«Êý¾ÝºÍÊý¾Ý¿â¶ÔÏó´ÓÒ»¸öÊý¾Ý¿â¸´Öƺͷַ¢µ½ÁíÒ»¸öÊý¾Ý¿â£¬È»ºóÔÚÊý¾Ý¿â¼ä½øÐÐͬ²½£¬ÒÔά³ÖÒ»ÖÂÐÔ¡£Ê¹Óø´ÖÆ£¬¿ÉÒÔÔÚ¾ÖÓòÍøºÍ¹ãÓòÍø¡¢²¦ºÅÁ¬½Ó¡¢ÎÞÏßÁ¬½ÓºÍ Internet ÉϽ«Êý¾Ý·Ö·¢µ½²»Í¬Î»ÖÃÒÔ¼°·Ö·¢¸øÔ¶³Ì»òÒÆ¶¯Óû§¡£
            ¼ÈȻͬÒå´ÊºÍ¸´Öƶ¼ÓÐͬ²½Êý¾ÝµÄ×÷Óã¬ÄǹؼüµÄÇø±ðµãÔÚÄÄÀïÄØ£¿¶ÔÒ»¸öͬÒå´Ê¶ÔÏóµÄ²Ù×÷ʵ¼ÊÉϾÍÊǶÔʵ¼ÊÕæÊÇ´æÔÚµÄÄǸö¶ÔÏóµÄ²Ù×÷£¬Í¬Òå´Ê¶ÔÏóÆäʵ¾ÍÖ»ÊÇÒ»¸öÕæÊǶÔÏóµÄ¿½±´£¬ÒªÏëͨ¹ýͬÒå´Ê´ïµ½¶Ô¶à¸öÊý¾Ý¿âµÄͬһ¸ö¶ÔÏó½øÐÐͬʱ¸üÐÂÊDz»¿ÉÄܵģ»¶ÔÓÚ¸´ÖƼ¼Êõ¶øÑԾͿÉÒÔ´ïµ½¸ü¸ÄÒ»¸öÊý¾Ý¿âÖеĶÔÏó¾Í¿ÉÒÔͬʱ¸ü¸ÄÈÎºÎÆäËüÊý¾Ý¿âÖеÄͬһ¶ÔÏóÁË
   


Ïà¹ØÎĵµ£º

ÅäËÍÅä»õµ¥ÉÌÆ·Ã÷ϸ²éѯ sql ÓÅ»¯

c06 --------------7545623Ìõ
c05---------------1032652Ìõ
vc01--------------427741Ìõ
  SQL Statement from editor:
  
  
     select c0602 "ÉÌÆ·±àÂë",c0625 "ÉÌÆ·ÌõÂë",
  c0103 "ÉÌÆ·Ãû³Æ",c0104 "¹æ¸ñ",c060 ......

SQL Server 2005 18452,18470µÇ¼´íÎóµÄ½â¾ö·½·¨

±¾ÎĵØÖ·£ºhttp://qzone.qq.com/blog/236000056-1217427602
ÎÞ·¨Á¬½Óµ½·þÎñÆ÷  
·þÎñÆ÷£ºÏûÏ¢18452, ¼¶±ð16£¬×´Ì¬1  
[Microsoft][ODBC  SQLServer Driver][SQL Server]Óû§‘sa’µÇ½ʧ°Ü¡£Ô­Òò£ºÎ´ÓëÐÅÈÎSQL     ServerÁ¬½ÓÏà¹ØÁª  
¸Ã´íÎó²úÉ ......

SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö

×î½ü¼¸ÖÜÒ»Ö±ÔÚ½øÐÐÊý¾Ý¿âÅàѵ£¬ÀÏʦ¾«Õ¿µÄ¼¼ÊõºÍÉú¶¯µÄ½²½âʹÎÒÊÜÒæ·Ëdz¡£ÎªÁËÈøü¶àµÄÐÂÊÖÊÜÒæ£¬ÎÒ³é¿Õ°ÑSQLÓï¾äÓÅ»¯²¿·Ö½øÐÐÁËÕûÀí£¬Ï£Íû´ó¼ÒÒ»Æð½ø²½¡£¡¡¡¡
¡¡¡¡Ò»¡¢²Ù×÷·ûÓÅ»¯¡¡¡¡
¡¡1¡¢IN ²Ù×÷·û ¡¡¡¡
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊÇ±È½Ï ......

SQLÖÐIN,NOT IN,EXISTS,NOT EXISTSµÄÓ÷¨ºÍ²î±ð


SQLÖÐIN,NOT IN,EXISTS,NOT EXISTSµÄÓ÷¨ºÍ²î±ð:
IN:È·¶¨¸ø¶¨µÄÖµÊÇ·ñÓë×Ó²éѯ»òÁбíÖеÄÖµÏàÆ¥Åä¡£
IN ¹Ø¼ü×ÖʹÄúµÃÒÔÑ¡ÔñÓëÁбíÖеÄÈÎÒâÒ»¸öֵƥÅäµÄÐС£
µ±Òª»ñµÃ¾ÓסÔÚ California¡¢Indiana »ò Maryland ÖݵÄËùÓÐ×÷ÕßµÄÐÕÃûºÍÖݵÄÁбíʱ£¬¾ÍÐèÒªÏÂÁвéѯ£º
SELECT ProductID, ProductName from Northwind.dbo.Pro ......

SQLÊý¾Ý¿âÖÐÓÃimageÀ´´æ´¢Îļþ

SQLÊý¾Ý¿âÖÐÓÃimageÀ´´æ´¢Îļþ,µ«SQLûÓÐÌṩֱ½ÓµÄ´æÈ¡ÎļþµÄÃüÁî.
/*--bcp ʵÏÖ¶þ½øÖÆÎļþµÄµ¼Èëµ¼³ö
 Ö§³Öimage,text,ntext×ֶεĵ¼Èë/µ¼³ö
 imageÊʺÏÓÚ¶þ½øÖÆÎļþ,°üÀ¨:WordÎĵµ,ExcelÎĵµ,ͼƬ,ÒôÀÖµÈ
 text,ntextÊʺÏÓÚÎı¾Êý¾ÝÎļþ
 ×¢Òâ:µ¼Èëʱ,½«¸²¸ÇÂú×ãÌõ¼þµÄËùÓÐÐÐ
  µ¼³öʱ,½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ