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

SQl Cookbookѧϰ±Ê¼Ç

1.select  * from A where a.a='a';
  Ö´ÐÐ˳Ðò ÏÈÖ´ÐÐ from ÔÚÖ´ÐÐ where ÖеĶ«Î÷ £¬×îºóÖ´ÐÐ select
2.ÁÐÖµÁ¬½Ó db2 oracle ||  , mysql concat(column1,'sss',column2) sqlServlerʹÓÃ+Á¬½Ó;
3. case when  ±í´ïʽ then ''
            when  ±í´ïʽ then ''
             else    ''
   end
4. ÏÞÖÆ·µ»ØµÄÐÐÊý
 ÔÚoracleÖÐʹÓÃrownum <= n ÏÞÖÆÐÐÊý
 ÔÚdb2ÖÐʹÓÃfetch first 5 rows only
 ×¢Òâ oracleÖÐÈç¹ûʹÓÃrownum =5 Êǵò»µ½µÚÎåÐеģ¬ÒòΪoracleµÄ²éѯԭÀí»ñȡһÐк󸳸øÐкţ¬Èç¹ûÐкÅÂú×ãÌõ¼þ·µ»Ø·ñÔòÉáÆú£¬ÕâÑùÓÀÔ¶µÃ²»µ½µÚÎåÐУ¬ÓÀÔ¶ÊǵÚÒ»ÐкŲ¢½ÓÉáÆú£¬ËùÒÔÒªÏëµÃµ½µÚÎåÐУ¬±ØÐëµÃµ½Ç°ËÄÐУ¬ËùÒÔ²éѯǰÎåÐбØÐëÊÇ<= 5;
5.null ÒªÏëÅжÏÖµÊÇ·ñΪnull±ØÐëΪ is null  £¬ null²»ÄÜÓõÈÓÚ=ºÍ²»µÈÓÚ<> ºÍÈκÎÖµ±È½Ï°üÀ¨null
6¡£°´Ä£Ê½²éѯ like '%a' 


Ïà¹ØÎĵµ£º

ÌØÊâSQLÓï¾ä

1.²éѯÁ¬½Óµ½Ä³Êý¾Ý¿âµÄÁ¬½ÓÊý
   select   count(*)   as   Á¬½ÓÊý   from   master..sysprocesses   where   db_name(dbid)='Êý¾Ý¿âÃû' ......

ÓÃTSQL°ÑAccessµÄ±íµ¼Èëµ½Ô¶³ÌSql Server

ÓÃTSQL°ÑAccessµÄ±íµ¼Èëµ½Ô¶³ÌSql Server£º
°Ñaccess µÄ.mdbÀït_itemList ±íµÄÊý¾Ý²åÈëµ½Ô¶³ÌSqlServerµÄt_itemL1111111±íÀï¡£
SELECT  top 10 *  INTO  t_itemL1111111 IN [ODBC] 
[ODBC;Driver=SQL Server; UID=jyb;PWD=jyb;Server=10.1.18.49;DataBase=ËùÓкϲ¢;]
    &nb ......

½²½âMSSQLÊý¾Ý¿âÖÐSQLËø»úÖÆºÍÊÂÎñ¸ôÀë¼¶±ð

Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......

³£ÓõÄWORDPRESS µÄSQLÓï¾ä


ÏÂÃæËùÓеÄSQLÓï¾ä¶¼ÊÇÕë¶Ôǰ׺Ϊwp_µÄ±í£¬Èç¹ûÄãµÄ±íǰ׺²»ÊÇwp_£¬Çë×öÏàÓ¦µÄÐÞ¸Ä
1.¸ü¸Äwordpress°²×°ºÍÊ×Ò³µØÖ·
Èç¹ûÄã¸ü»»ÓòÃû»òÕß°ÑwordpressµÄ°²×°Ä¿Â¼½øÐÐÁ˱䶯¾ÍÐèÒª½øÐÐÐ޸ģ¬
UPDATE wp_options SET option_value = replace(option_value, ‘¾ÉÍøÖ·’, ‘ÐÂÍøÖ·’) WHERE option_name ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ