SqlServer ËøµÄÎÊÌâ
SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran
ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ÒªµÈÕâÌõ¸üÐÂÍê±Ï¡£
Ôõô²ÅÄÜËø¶¨Ò»Ìõ¼Ç¼°¡£¿
SQL SERVERËø²»×¡Ò»ÐеÄ,»áÉý¼¶ÎªÒ³¼¶Ëø»ò±í¼¶Ëø¡£
²»ÄÜËøÒ»Ðа¡£¿
ËøÕû¸ö±í ²»Ì«ÓѺðÉ
update ºÃÏñ±¾Éí»á×Ô¼º¼ÓÐÐËø.
Code¼ÓÉÏË÷ÒýÔÙÊÔ¡£
SQL code:
---²Î¿¼£º
¡ôÎÊÌâÃèÊö
ÏëÔÚ¼ìË÷Ò»ÅúÊý¾ÝµÄͬʱ£¬¼ÓÉϸüÐÂËø£¬ÒÔ½ûÖ¹ÆäËû¶ËÄ©µÄ¸üС£²»ÊÇ±í¼¶,Ò³¼¶¼ÓËø£¬×ÔÈ»¶øÈ»Ïëµ½ÁËÐм¶¼ÓËø¡£
µ«ÊÇ£¬·¢ÏÖ¼ìË÷³öÀ´µÄ¼Ç¼ÒÔÍâµÄÊý¾ÝÒ²±»¼ÓÉÏËøÁË¡£ ¡ôÎÊÌâ·ÖÎö
tabale
----------------------------------------------------×Ö¶Î C1£¨key1£© C2£¨ key2£© C3 ............
c1001 c2003 c3001
c1002 c2002 c3001
c1003 c2001 c3001Ë÷Òý IX_TEST (C2,C1)
----------------------------------------------------Óû§A£¬Óû§B£¬¹«Óò¿·ÖSQL
set lock_timeout 0
begin transaction
select * from TEST with (index=IX_TEST,rowlock,updlock)CASE¢Ù
Óû§A
where C1 ='c1003'
½á¹û-- c1003 c2001
Ïà¹ØÎÊ´ð£º
ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½ ......
mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ
±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©
ûÓС£
³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£
½èÖúÆäËûÓïÑÔ
ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£
......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
......
ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£
ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö3¸ö·ÖÇø£¬Îļþ·Ö²¼ÔÚ²»Í¬· ......