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

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Ëø²»×¡Ò»ÐеÄ,»áÉý¼¶ÎªÒ³¼¶Ëø»ò±í¼¶Ëø¡£

ÒýÓÃ
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


Ïà¹ØÎÊ´ð£º

ÎÊÌ⣺ͨ¹ýsql ö¾Ùsqlserver ÉϽ¨Á¢µÄÁ´½Ó·þÎñÆ÷Áбí

ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½ ......

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

SQLSERVER 2000 ÔÚ RAID·þÎñÆ÷ÉÏ£¬¸ÃÈçºÎÅäÖã¿

ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£

ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö3¸ö·ÖÇø£¬Îļþ·Ö²¼ÔÚ²»Í¬· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ