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

MsSql ²é¿´ÐÅÏ¢ºÃÓï¾ä

set statistics profile on
set statistics io on
set statistics time on
select top 1 * from et_order order by pkid desc
½á¹ûÈçÏ£º
SQL Server ·ÖÎöºÍ±àÒëʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
(1 ÐÐÊÜÓ°Ïì)
±í 'ET_Order'¡£É¨Ãè¼ÆÊý 1£¬Âß¼­¶ÁÈ¡ 4 ´Î£¬ÎïÀí¶ÁÈ¡ 0 ´Î£¬Ô¤¶Á 0 ´Î£¬lob Âß¼­¶ÁÈ¡ 0 ´Î£¬lob ÎïÀí¶ÁÈ¡ 0 ´Î£¬lob Ô¤¶Á 0 ´Î¡£
(3 ÐÐÊÜÓ°Ïì)
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 8 ºÁÃë¡£
ÁíÒ»¸ö°ì·¨Îª£º
declare   @begin_date   datetime  
  declare   @end_date   datetime  
  select   @begin_date   =   getdate()  
  exec   ´æ´¢¹ý³Ì    
  select   @end_date   =   getdate()  
  select   datediff(ms,@begin_date,@end_date)   as   'ÓÃʱ/ºÁÃë'


Ïà¹ØÎĵµ£º

ͼÎÄÏê½âSilverlight·ÃÎÊMSSQLÊý¾Ý¿â

ÔÚÒø¹âÖйúÍø£¨SilverlightChina.Net£©ÓÐһƪ"SilverlightÓë³£ÓÃÊý¾Ý¿â»¥²Ù×÷ϵÁÐ"ÎÄÕ£¬ÆäÖнéÉÜÁËʹÓÃSilverlight´æÈ¡²»Í¬Êý¾Ý¿âµÄ·½·¨ºÍ²½Öè¡£µ«ÊǶÔÓÚSilverlight´æÈ¡MS SQL½éÉܵIJ»¹»È«Ã棬ÕâÀïÎÒÏë½éÉÜSilverlightÈçºÎͨ¹ýWCF·ÃÎÊMSSQLÊý¾Ý¿â´æ´¢¹ý³ÌµÄ¡£Ï£Íû¶Ô´ó¼ÒÄܹ»ÓÐËù°ïÖú¡£
ÎÒÃÇҪʵÏÖ£¬ Óû§ÊäÈëÓû§ÃûºÍÃÜ ......

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 ÐУ©
*/ ......

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µÄn ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ