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

SQL¾ÛºÏº¯


SQL¾ÛºÏº¯
±êÇ©£ºsql¾ÛºÏº¯Êý ÔÓ̸ 
 
¾ÛºÏº¯Êý£º
1.AVG ·µ»Ø×éÖÐµÄÆ½¾ùÖµ£¬¿ÕÖµ½«±»ºöÂÔ¡£
ÀýÈ磺use  northwind   // ²Ù×÷northwindÊý¾Ý¿â
   Go
   Select  avg (unitprice)   //´Ó±íÖÐÑ¡ÔñÇóunitpriceµÄƽ¾ùÖµ
      from  products
      Where  categoryid = ‘8’
2£® BINABY_CHECKSUM  ¿ÉÓÃÓÚ¼ì²â±íÖÐÐеĸü¸Ä
·µ»ØÖµÓɱí´ïʽµÄÔËËã½á¹ûÀàÐ;ö¶¨
ÀýÈ磺use northwind
             Go
      Create  table  tablebc(productid int,bchecksum int)   //½¨Á¢ÓÐÁ½¸öÊôÐԵıí
      Insert  into tablebc   //Ïò±íÖвåÈëÊý¾Ý
          Select  priductid,binary_checksum(*)
          from  products
    Update  products   //¸üÐÂ
      Set  productname=’oishi tofu’, unitprice=20 where  productname = ‘tofu’
  
   Update  products   //¸üÐÂ
   Set  priductname=’oishi konbu’, unitprice = 5 where priductname=’konbu’
      Update priducts     //¸üÐÂ
   Set  prodctname=’oishi genen shouyu’, unitprice =12
           Where priductname=’genen shouyu’          
     Select  productid    //Ìô³ö±ä»¯µÄÐÐ
    from tablebc
    Where exists (
Select productid from products
Where  product.productid = tablebc.productid and
binary_checksu (*) <> tablebc.bchecksum)  //±êÖ¾³ö±ä»¯µÄÐÐ
3.CHECKSUM


Ïà¹ØÎĵµ£º

SqlÓÅ»¯·½·¨

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

sqlÓÅ»¯ ¶Ôlike ¡®%xx%¡¯ µÄÌæ»»

ÔÚSQLÖпÉÒÔʹÓÃLike½øÐÐÄ£ºý²éѯ£¬ÀýÈç f_stuname like 'a%' ²éѯf_stunameÁÐÒÔa¿ªÍ·µÄ¼Ç¼¡£
µ±ÎÒÃÇÔÚÓ¦ÓÃÖÐʹÓÃ
f_stuname
like '%a%' ʱ£¬Èç¹û

f_stunameÓÐË÷ÒýµÄ»°£¬Õâ¸öË÷ÒýÒ²ÊDz»Ö´ÐеÄ
ÔÚSQLÓÅ»¯ÖÐÕâ¸öд·¨¾ÍÊÇÒ»¸ö²»ºÃµÄSQLÁË¡£
ÄÇôÈçºÎÀ´Ìæ»»Õâ¸öÄØ£¬ÕâÒ»¸ö¾ÍÓõ½ÁËOracleµÄinstrº¯ÊýÁË
ÎÒÃÇ¿ÉÒÔÕâÑù ......

ÔÚSQL SERVER 2005/2008ÖÐÓµÓÐÒ»¸ö¶ÔÏó

ÔÚSQL SERVER 2005/2008ÖÐÓµÓÐÒ»¸ö¶ÔÏó
´ÓSQL SERVER2000Éý¼¶µ½2005/2008ºó£¬Ò»¸öÎÒÃDZØÐëÖØÐÂÈÏʶµÄÇé¿öÊǶÔÏó²»ÔÙÓÐËùÓÐÕߣ¨owner£©¡£¼Ü¹¹°üº¬¶ÔÏ󣬼ܹ¹ÓÐËùÓÐÕß¡£Èç¹ûÄã²éѯ±ísys.objects£¬Ä㽫»á¿´µ½Õâ¿´ÆðÀ´ÊÇÕýÈ·µÄ£¬Ö»ÊDZíÖл¹ÓÐÒ»¸ö×Ö¶Îprincipal_id£¬µ«ÊÇÒ»°ãÇé¿öÏÂËü×ÜÊÇNULLÖµ¡£²»¾ÃǰһÌ죬ÎÒͻȻ¶Ôprincipal ......

SQL ×Ö·û´®º¯Êý

SQL×Ö·û´®º¯Êý
Òª¿´aµÄASCIIÂ룬sqlÓï¾ä
select ascii(a)
Òª¿´ASCIIÂëΪ56µÄ×Ö·û
select char(56)
ASCII() --º¯Êý·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ
CHAR() --º¯ÊýÓÃÓÚ½«ASCII Âëת»»Îª×Ö·û
--Èç¹ûûÓÐÊäÈë0 ~ 255 Ö®¼äµÄASCII ÂëÖµCHAR º¯Êý»á·µ»ØÒ»¸öNULL Öµ
LOWER() --º¯Êý°Ñ×Ö·û´®È«²¿×ª»»ÎªÐ¡Ð´
UPPER() ......

SQL×¢Èë

    SQL×¢Èë¹¥»÷µÄΣº¦ÐԺܴó¡£ÔÚ½²½âÆä·ÀÖ¹°ì·¨Ö®Ç°£¬Êý¾Ý¿â¹ÜÀíÔ±ÓбØÒªÏÈÁ˽âÒ»ÏÂÆä¹¥»÷µÄÔ­Àí¡£ÕâÓÐÀûÓÚ¹ÜÀíÔ±²ÉÈ¡ÓÐÕë¶ÔÐԵķÀÖδëÊ©¡£
¡¡¡¡Ò»¡¢ SQL×¢Èë¹¥»÷µÄ¼òµ¥Ê¾Àý¡£
¡¡¡¡statement := "SELECT * from Users WHERE Value= " + a_variable + "
¡¡¡¡ÉÏÃæÕâÌõÓï¾äÊÇºÜÆÕͨµÄÒ»ÌõSQLÓï¾ä£¬ËûÖ÷Ҫʵ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ