Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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   Ô´Êý¾Ý±í"   (°ÑÔ´Êý¾Ý±íµÄ¼Ç¼


Ïà¹ØÎĵµ£º

SQL Server 2008 ¸½¼ÓÊý¾Ý¿âʧ°ÜµÄ½â¾ö°ì·¨

×òÌìÔÚ½«Ò»¸ö SQL Server 2000 Êý¾Ý¿â¸½¼Óµ½ SQL Server 2008 ʱ³öÏÖÈçϵĴíÎó£º
¸½¼ÓÊý¾Ý¿â ¶ÔÓÚ ·þÎñÆ÷“servername”ʧ°Ü¡£  (Microsoft.SqlServer.Smo)
ÎÞ·¨Éý¼¶Êý¾Ý¿â ‘dbname’£¬ÒòΪËüÊÇÖ»¶ÁµÄ£¬»òÕß¾ßÓÐÖ»¶ÁÎļþ¡£Ç뽫Êý¾Ý¿â»òÎļþÉèΪ¿Éд£¬È»ºóÖØÐÂÔËÐлָ´²Ù×÷¡£ (Microsoft SQL S ......

¶ÔSQL Server 2008 R2¸ÐÐËȤStreamInsightÌØÐÔ

SQL Server 2008 R2µÄÊ®´ó±ä»¯£¨ÉÏ£©£¬SQL Server 2008 R2µÄÊ®´ó±ä»¯£¨Ï£© ÕâÊ®´óÌØÐÔÖÐÎұȽϸÐÐËȤµÄÊÇStreamInsight£ºÍ¨¹ýSQL Server 2008 R2еÄStreamInsight×é¼þ£¬Microsoft½øÈëÁ˸´ÔÓʼþ´¦Àí(Complex Event Processing£¬CEP)¾ºÕù£¬ÆäÖÐÏà¹ØµÄ¹©Ó¦ÉÌ»¹ÓÐOracle¡¢IBMºÍStreamBase¡£
SQL Server 2008 R2ÒýÈëStreamIn ......

SQL Server 2008 ¶¨Ê±×÷Òµ

--SQL Server 2008 ¶¨Ê±×÷ÒµµÄÖÆ¶¨
--1.´ò¿ª¡¾SQL Server Management Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿ÁбíÖÐÑ¡Ôñ¡¾SQL Server ´úÀí¡¿£»
--2.Êó±êÓÒ»÷¡¾SQL Server ´úÀí¡¿£¬Ñ¡Ôñ¡¾Æô¶¯(S)¡¿£¬ÈçÒÑÆô¶¯£¬¿ÉÒÔÊ¡ÂԴ˲½Ö裻
--3.Õ¹¿ª¡¾SQL Server ´úÀí¡¿ÁÐ±í£¬ÓÒ»÷¡¾×÷Òµ¡¿-->¡¾Ð½¨×÷Òµ¡¿£»
--3.1  ÔÚ¡¾³£¹æ¡¿Ñ¡Ïî ......

ÈçºÎÅäÖà SQL Server 2005 ÒÔÔÊÐíÔ¶³ÌÁ¬½Ó

½ñÌìÔÚÒ»¸öVPSÉϰ²×°sql2005£¬°²×°ºÃºó±¾µØÒ»Ö±Á¬½Ó²»ÉÏ
¼ò½é
ÔÚ³¢ÊÔ´ÓÔ¶³Ì¼ÆËã»úÁ¬½Óµ½ Microsoft SQL Server 2005 ʵÀýʱ£¬¿ÉÄÜ»á½ÓÊÕµ½´íÎóÏûÏ¢¡£ÔÚʹÓÃÈκγÌÐòÁ¬½Óµ½ SQL Server ʱ¶¼¿ÉÄܻᷢÉú´ËÎÊÌâ¡£ÀýÈ磬ÔÚʹÓà SQLCMD ʵÓù¤¾ßÁ¬½Óµ½ SQL Server ʱÊÕµ½ÒÔÏ´íÎóÏûÏ¢£º
Sqlcmd:´íÎó:Microsoft SQL Native Cli ......

sqlµÝ¹é²éѯ

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