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

SQL »ù±¾²Ù×÷ ɾ³ý ÐÞ¸Ä Ë¢ÐÂ

SQL³£ÓÃÃüÁîʹÓ÷½·¨£º    
   
  (1)   Êý¾Ý¼Ç¼ɸѡ£º    
   
  sql="select   *   from   Êý¾Ý±í   where   ×Ö¶ÎÃû=×Ö¶ÎÖµ   order   by   ×Ö¶ÎÃû   [desc]"    
   
  sql="select   *   from   Êý¾Ý±í   where   ×Ö¶ÎÃû   like   '%×Ö¶ÎÖµ%'   order   by   ×Ö¶ÎÃû   [desc]"    
   
  sql="select   top   10   *   from   Êý¾Ý±í   where   ×Ö¶ÎÃû   order   by   ×Ö¶ÎÃû   [desc]"    
   
  sql="select   *   from   Êý¾Ý±í   where   ×Ö¶ÎÃû   in   ('Öµ1','Öµ2','Öµ3')"    
   
  sql="select   *   from   Êý¾Ý±í   where   ×Ö¶ÎÃû   between   Öµ1   and   Öµ2"    
   
  (2)   ¸üÐÂÊý¾Ý¼Ç¼£º    
   
  sql="update   Êý¾Ý±í   set   ×Ö¶ÎÃû=×Ö¶ÎÖµ   where   Ìõ¼þ±í´ïʽ"    
   
  sql="update   Êý¾Ý±í   set   ×Ö¶Î1=Öµ1,×Ö¶Î2=Öµ2   ……   ×Ö¶În=Öµn   where   Ìõ¼þ±í´ïʽ"    
   
  (3)   ɾ³ýÊý¾Ý¼Ç¼£º    
   
  sql="delete   from   Êý¾Ý±í   where   Ìõ¼þ±í´ïʽ"    
   
  sql="delete   from   Êý¾Ý±í"   (½«Êý¾Ý±íËùÓмǼɾ³ý)    
   
  (4)   Ìí¼ÓÊý¾Ý¼Ç¼£º    
   
  sql="insert   into   Êý¾Ý±í   (×Ö¶Î1,×Ö¶Î2,×Ö¶Î3   …)   valuess   (Öµ1,Öµ2,Öµ3   …)"    
   
  sql="insert   into   Ä¿±êÊý¾Ý±í   select   *   from   Ô´Êý¾Ý±í"   (°ÑÔ´Êý¾Ý±íµÄ¼Ç¼


Ïà¹ØÎĵµ£º

asp.net½áºÏaspnetpagerÓÃsqlÓï¾ä·ÖÒ³

Êý¾Ý¿â²Ù×÷Àࣺ
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
/// <summary>
/// È¡µÃ×ÜÊý
/// </summary>
/// <returns></returns>
public string getTotal()
{
StringBuilder sb = new StringBuilder();
sb.Append("select count(*) total from Test");
DataTable dt = DBHelper.ExecuteDt(sb.ToString ......

SQL½âÃÜctext×Ö¶ÎÄÚÈݺ¯Êý

--SQL½âÃÜctext×Ö¶ÎÄÚÈݺ¯Êý
--exec sp_decrypt 'Ô¼ÊøÃû³Æ'
--exec sp_decrypt 'DF_InsuranceRecord_PeriodUnit'
--exec sp_decrypt '´æ´¢¹ý³ÌÃû³Æ'
--exec sp_decrypt 'sp_SearchPrinting_InsuranceRecord'
--Ö÷ÒªÓÃ;:¶ÁÈ¡systemcommentsÖеÄ×Ö¶ÎÄÚÈÝ¡£°üÀ¨Ô¼Êø,´æ´¢¹ý³ÌµÈµÈ¡£
--Ô­ÎÄÓ¦¸ÃÀ´×Ôhttp://blog.csdn.net ......

SQL string to date time

ÔÚSQL serverÖо­³£»áת»»stringµ½datetimeÀàÐÍ£¬×î³£Óõĺ¯Êý¾ÍÊÇConvert¡£ÄÇô¶ÔConvertÕâ¸öº¯Êý£¬²»µÃ²»ÏêϸµÄÑо¿Ò»Ï¡£ConvertÕâ¸öº¯ÊýµÄ¹¦ÄܺÜÇ¿´ó£¬¸ñʽÓֺܼòµ¥CONVERT ( data_type [ ( length ) ] , expression [ , style ] )¡£µ¥¾Í½«stringµ½datetimeÀàÐ͵Äת»»¾ÍÓкܶàÑùʽ¡£Èç: Convert(datetime, expression), ......

sql´óÊý¾Ý²Ù×÷ÈçºÎÓÅ»¯

¾ßÌåҪעÒâµÄ£º  
1.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺  
select id from t where num is null  
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º  
select id from t where num=0 &n ......

sqlµÝ¹é²éѯ

ÔÚ¹¤×÷ÖÐÓöµ½Ò»¸öÎÊÌâ,ÊÇÐèÒªsqlµÝ¹é²éѯµÄ.²»¶®,ÓÚÊǵ½csdnÉÏÈ¥ÎÊ,ÄÇÀïµÄЧÂÊÕæÊǷdz£¸ß,ÎÒÒÔǰҲûÔÚÉÏÃæÎʹýÎÊÌâ.
ÎÊÌâÃèÊö:
ÎÒÓÐÒ»¸ö±í½á¹¹ÈçÏÂ:
id upperid
1     2
3     2
4     1
5     3
¾ßÌå²ã´Î²»ÖªµÀ,ÎÒÏëÓõݹésqlÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ