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

MSSQLµÄһЩÓ÷¨¼¯ºÏ

ÔÚselect語¾äÀïÃæ¿ÉÒÔʹÓÃcase來對ij個colmunµÄÖµ進ÐзÖ別處Àí£¬±ÈÈç
select case color
when 1 then 'red'
when 2 then 'green'
when 3 then 'blue'
else 'black'
end as 'colorName',
foodName from foods
Èç¹ûʹÓÃÁËleft joinµÄ時ºò£¬Ä³個columnµÄnullÖµÐèÒª給Ò»個default valueµÄ話£¬Ò²¿ÉÒÔÈçÏ£º
select foodName, case 
when foodPrice is null then 0
else foodPrice
end as price,
foodCost from foods left join foodPrices on foods.foodId = foodPrices.foodId
»òÕß
when nullif(foodPrice, null) is null then 0


Ïà¹ØÎĵµ£º

MSSQLÈÕÖ¾Îļþ¼°Æä´¦ÀíÏê½â


ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
   ÈýÖÖ·½·¨£º  
    
1¡¢É¾³ýLOG  
    
   1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â      
   2)£ºÉ¾³ýLOGÎļþ  & ......

MSSQLµÄIndexÒ²ÒªÓÅ»¯¡£

ÔÚ´¦ÀíϵͳÓÅ»¯µÄʱºò£¬·¢ÏÖindexʹÓò»µ±µÄ»°£¬ÏµÍ³µÄÐÔÄܲ»Äܺܺ÷¢»Ó¡£
È磺½ñÌìµÄ·¢ÏÖµÄÒ»¸ösqlÓï¾ä£¬¾­¹ý·ÖÎö£¬Ê¹ÓÃÁË2¸öindex¡£µ«ÊÇ2¸öindex·µ»ØµÄ¼Ç¼ÔÚ»¥ÏàÆ¥Åä¹ý³ÌÖкÄʱ×î¶à¡£ËùÒÔ£¬¼´Ê¹SQLÓï¾äʹÓÃindex£¬Ò²²»´ú±íÕâ¸öÓï¾äÔÚÐÔÄÜÉÏÊǺܺõġ£ ......

mssqlµÇ¼ÃûºÍÿ¸öÊý¾Ý¿âµÄÓû§µÄÇø±ðÁªÏµ


ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾­³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......

ASP.netÒ³ÃæʵÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬ÊÇ¿â´´½¨£¡

///   <summary>  
        ///   ´´½¨Êý¾Ý¿â¡£  
        ///   </summary>
        ///   <param name="srvName">±íÊ ......

MSSQLÈ«ÎļìË÷

MSSQLÈ«ÎļìË÷ --1.´ò¿ªÊý¾Ý¿â
use pubs
go
--2.´ò¿ªÈ«ÎÄË÷ÒýÖ§³Ö
--execute sp_fulltext_database 'enable'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ