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

ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°

°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃæ£¬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô»°¿ò£¬ÇëÎÊÕâÊÇΪºÎ£¿


Õâ¸ö°²×°³ÌÐòÎÒ¹ýÈ¥Ò»Ö±ÔÚÓ㬶¼ÓÃÁËÎå¡¢Áù´ÎÁË£¬¹ýȥһֱû³öÏÖ¹ýÕâÖÖÎÊÌâ¡£

ÒýÓÃ
×°ÔÚDÅÌÊÔÊÔ¡£

ÎÒ²»ÊÇ˵ÁËÂð£¬ÎÒ²»¹Ü»»Ê²Ã´Â·¾¶£¬¶¼ÌáʾÕâ¸ö´í¡£

ÒýÓÃ
Õâ¸ö°²×°³ÌÐòÎÒ¹ýÈ¥Ò»Ö±ÔÚÓ㬶¼ÓÃÁËÎå¡¢Áù´ÎÁË£¬¹ýȥһֱû³öÏÖ¹ýÕâÖÖÎÊÌâ¡£

ÓпÉÄÜÄãµÄ²Ù×÷ϵͳÓÐÎÊÌ⣬±È½ÏÊܵ½²¡¶¾¹¥»÷µÈ¡£

¹À¼Æ»¹ÊÇÂ¥Ö÷µÄ×¢²á±í³öÎÊÌâÁË ÏÈÕÒ¸öÇåÀí¹¤¾ßÇåÀíÏ ȻºóÔÙÊÔ ÎÒ¾õµÃÓпÉÄÜÊÇÄãµÄϵͳ³öÁËÒ»µãÎÊÌâ

ÒýÓÃ
ÒýÓà 3 Â¥ skyisland µÄ»Ø¸´:
Õâ¸ö°²×°³ÌÐòÎÒ¹ýÈ¥Ò»Ö±ÔÚÓ㬶¼ÓÃÁËÎå¡¢Áù´ÎÁË£¬¹ýȥһֱû³öÏÖ¹ýÕâÖÖÎÊÌâ¡£

ÓпÉÄÜÄãµÄ²Ù×÷ϵͳÓÐÎÊÌ⣬±È½ÏÊܵ½²¡¶¾¹¥»÷µÈ¡£

ÎÒ½ñÌì9µãÔ糿¸Õ¸ÕÖØ×°ÏµÍ³£¬10µã¸Õ´òÍê112¸ö©¶´²¹¶¡£¬²¢×°ÉÏÁËÕý°æÉ±¶¾Èí¼þ¡£

ÒýÓÃ
¹À¼Æ»¹ÊÇÂ¥Ö÷µÄ×¢²á±í³öÎÊÌâÁË ÏÈÕÒ¸öÇåÀí¹¤¾ßÇåÀíÏ ȻºóÔÙÊÔ ÎÒ¾õµÃÓпÉÄÜÊÇÄãµÄϵͳ³öÁËÒ»µãÎÊÌâ

ÎÒÔÚ°²×°¹ý³ÌÖÐÑ¡ÔñÁË¡°Öؽ¨×¢²á±í¡±Ñ¡Ï²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌâ¡£

ÖØÆôһϾÓÈ»ºÃÁË


Ïà¹ØÎÊ´ð£º

ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ

ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..

ÕâÀï¾ÍÊÇ

ÕâÀï±ÈQQȺÀïÈÈÄÖ

ÎÒÒ²ÏëÕÒÕâô¸öȺ

.

SQL code:
¡£¡£¡£¡£¡£

¡£

ºÇºÇ

ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ


ͬÒâ

發錯° ......

sqlserver Êý¾Ý¿âËÀËøºó¶à³¤Ê±¼ä½âËø£¿

¸÷λ´óÏÀ£¬sqlserver Êý¾Ý¿âËÀËøºó£¬»á²»»á×Ô¶¯½âËøÄØ£¿¶à³¤Ê±¼äÄÜ×Ô¶¯½âËøÄØ£¿Ð»Ð»£¡
SQL code:
use master
go
create procedure sp_who_lock
as
begin
declare @spid int,@bl int,
@intTransactionCountO ......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

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