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

SQLÓï¾ä»ã×Ü

SQL :Structured Query Language½á¹¹»¯²éѯÓïÑÔ
1.Select [Predicate] *(filed) from table/view Where ... Group by ... Having... Order by ... With ...
   Predicate£º°üÀ¨all/Distinct/Distinctrow/Top£¬ÏÞÖƲéѯ½á¹û£»
   As¿ÉÒÔÃüÃû±ðÃû£»
   Where ... Ö¸¶¨Ä³Ð©Ìõ¼þ£¬½«ËùÓзûºÏÌõ¼þµÄ¼Ç¼¹ýÂ˳öÀ´£¬ÏÂÃæÊÇSQLÌṩµÄÔËËã·ûºÍ¹Ø¼ü×Ö¡£
   ËãÊõÔËËã·û£º+¡¢-¡¢*¡¢/¡¢%
   ±È½ÏÔËËã·û:=¡¢<¡¢>¡¢>=¡¢<=¡¢<>
   ×Ö·û´®²Ù×÷±È½Ï·û£ºlike¡¢ not like
   Âß¼­²Ù×÷·û£ºand¡¢or¡¢not
   ÖµµÄÓò£ºBetween¡¢not between
   ÖµµÄÁÐ±í£ºin£¬not in
   δ֪µÄÖµ£ºis null¡¢is not null
   Group by ... ¶àºÍ¾ÛºÏº¯ÊýÒ»ÆðʹÓã¬sum¡¢avg¡¢count¡¢max¡¢min¡¢first¡¢last¡£
   Having... ×é»ò¾ÛºÏº¯ÊýµÄÌõ¼þÅжÏ
2.¸ß¼¶²éѯ
   UnionºÏ²¢¶à¸ö½á¹û¼¯¡£
   Inner joinÄÚÁª½Ó²éѯ¡£
   Outer joinÍâÁª½Ó²éѯ¡££¨Left/Right Outer join£©
   Trasform½»²æ±í²éѯ¡£
   Àý£ºTrasform sum£¨ÏúÁ¿£© as ÏúÁ¿ select ÓïÑÔÀàÐÍ from ͼÊéÏúÊÛ group by ÓïÑÔÀà±ð pivot ÏúÊÛʱ¼ä
   Case¾²Ì¬½»²æ±í¡££¨Case ... When ... Then ..else null end£© as [...]
   Óô洢¹ý³ÌʵÏÖ¶¯Ì¬½»²æ±í¡£
3.ÆäËû
   ¸ñʽ»¯º¯ÊýFormat£¨²ÎÊý£¬¸ñʽ£© ---²»Ö§³ÖSQL server
   ×Ö·û´®º¯Êý£ºMid¡¢Len
   ÈÕÆÚº¯Êý£ºDateDiff
   


Ïà¹ØÎĵµ£º

JSP + SQL server 2000¿ª·¢»·¾³µÄ´î½¨

     ´Ó×òÌ쿪ʼ¾ÍÒ»Ö±ÔÚÍøÉϲéÕÒÊý¾Ý¿âΪSQL server 2000 µÄJSP¿ª·¢»·¾³µÄ´î½¨£¬µ½ÏÖÔÚΪֹÖÕÓÚÄܹ»Õý³£Áª½Ó²¢·ÃÎÊ¡£ÒÔÏÂÊǴµÄ²½Ö裺
1¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQL server 2000 ¸öÈË°æµÄ°²×°°ü£¬°´ÕÕÌáʾ²Ù×÷£¬µ±ÔÚÉí·ÖÑé֤ʱ£¬Ñ¡Ôñ»ìºÏģʽ£¬Óû§saµÄÃÜÂë¿ÉÒÔΪ¿Õ£¬Ò²¿ÉÒÔ²»Îª¿Õ¡£
2¡¢´ÓÍøÉÏÏÂÔØÒ»¸öSQ ......

SQL Server 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½Ó½â¾ö·½·¨

¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈÏ°²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƬ»úÆ÷·­ÒëµÄÎÄÕ£¬ÊÇÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......

Á¬½Óms sqlÊý¾Ý¿âд·¨

windows ¼¯³ÉÑéÖ¤£º
<connectionStrings>
   <add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;database=Test;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
  </connectionStrings>
»òÕß
<connectionStrings>
<add name=" ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Èý£©

ʵÏÖСÊý¾ÝÁ¿ºÍº£Á¿Êý¾ÝµÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì
¡¡¡¡½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾­µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À´ÊµÏÖ·ÖÒ³¡£µ«ÕâÖÖ·ÖÒ³·½·¨½öÊÊÓÃÓÚ½ÏСÊý¾ÝÁ¿µÄÇéÐΣ¬ÒòΪÓα걾ÉíÓÐȱµã£ºÓαêÊÇ´æ·ÅÔÚÄÚ´æÖУ¬º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ