Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
¸´ÔÓÖ®´¦ÔÚÓÚ,Ðí¶à±íµÄĬÈÏÖµºÍȡֵ¼¯ºÏÐèÒªÓÉÆäËü±íÖеÄÊý¾Ý¾ö¶¨
ÁíÍâ¸÷´æ´¢¹ý³ÌÒª·µ»Ø¸÷ÖÖÇé¿öϵijö´í´úÂë,ÒÔ±ãǰ̨³ÌÐò´¦Àí
ÎÒ¿ÉÒÔ°ÑÎÒ½¨Á¢µÄÊý¾Ý¿â°ë³ÉÆ·,·¢ËÍÒÔ¹©²Î¿¼
ÓÐÒâÕßÇëÁôÏÂQQºÅ
¿ÉÒÔ°¡£¡ÇëÓëÎÒÁªÏµ£¡QQ£º404953714
Äܲ»ÄÜ·¢¸ö°ë³ÉÆ·¸øÎÒ¡£¡£¡£ÎÒÔÚѧÊý¾Ý¿â¡£¡£ÏëÁ·Ï°Ï¡£¡£¡£¸Ðл¡£¡£kiaqew@qq.com
QQ£º315054403
¾ÍÖ°ÖдóÐÍÖÆÔìÆóÒµ£¬¸ºÔðSQL SERVER 2000/2008¹ÜÀí¡¢¿ª·¢
ÔÚÏßʱ¼ä³äÔ£
Ïà¹ØÎÊ´ð£º
ÓÃsqlserver 2000 agent Éú³ÉÒ»¸öjob£¬¸ÄjobÀïÃæÓе÷ÓÃÒ»¸öÓ¦ÓóÌÐò£¬¸ÃÓ¦ÓóÌÐò»áÈ¥µ÷´òÓ¡»ú´òÓ¡
µ¥¶ÀÅÜÕâ¸öÓ¦ÓóÌÐòµ÷´òÓ¡»úÊÇÕýÈ·µÄ£¬ È»ºóÓÃsqlserver 2005ÀïµÄagentÈ¥µ÷Ò²ÊÇ¿ÉÒÔÕý³£´òÓ¡µÄ¡£¡£ ......
1.
select top 20 id,title,PageUrl from Infor
where title like 'ÒÔµÂÅäÌì,Ã÷µÂÉ÷%' order by id desc
CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 39 ºÁÃë¡£
2.
select top 20 id,title,PageUrl ......
¸÷λ´óÏÀ£¬sqlserver Êý¾Ý¿âËÀËøºó£¬»á²»»á×Ô¶¯½âËøÄØ£¿¶à³¤Ê±¼äÄÜ×Ô¶¯½âËøÄØ£¿Ð»Ð»£¡
SQL code:
use master
go
create procedure sp_who_lock
as
begin
declare @spid int,@bl int,
@intTransactionCountO ......
ÎÒ´Ó΢Èí¹ÙÍøÏÂÔØµÄdriverÔõôÊǸöhtmlÎļþ˸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔØ¶¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æÎªµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£
ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......