Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

JSPÀïÔõôʹÓÃSQLserver2000ÀïµÄdateÀàÐÍ£¿

SQLserver2000ÀïµÄdatetime£¨8£©ºÍsmalldatetime(4)ÔÚÊý¾Ý¿â²éѯ·ÖÎöÆ÷ÀïÏÔʾֻÓÐÄê-ÔÂ-ÈÕ£¬µ«ÊÇÔÚJSPÀïÏÔʾȴÊÇ
Äê-ÔÂ-ÈÕ 00£º00£º00.0
ÔõÑùʹÓÃSQLserverµÄÈÕÆÚÀàÐÍÄØ£¿
ÎÒ³¢ÊÔÁËÕâÑùµÄÓï¾ä£º
select ......

mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ

mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ
±ÈÈçsqlserverµÄ¹æÔòÈçÏÂ
create rule [IsSpecial] as @ in ('y','n')

Ëû¿ÉÒÔÖ¸¶¨×ֶεÄÖµ¡¡µÄ¡¡È¡Öµ·¶Î§
ÓÃÔ¼Êø¿ÉÒÔʵÏÖ

mysql ÖÐûÓÐÕâ¸öRUL ......

Access Êý¾ÝÉýǨµ½ SQLServer2005

ÎÒÔ­±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£
ÏÖÓÐÎÊÌâÈçÏ£º

1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô­±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......

Ôõô½«´øÌØÊâ×Ö·ûµÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿

Java code:

Ôõô½«ÏñÏÂÃæµÄ´øÌØÊâ×Ö·û(µ¥ÒýºÅ¡¢°Ù·ÖºÅ£¬Ë«ÒýºÅ£¬#ºÅ£¬ÃÀÔª·ûºÅ......)µÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿
String mystring="
insert into T_PUB_RZGL(N_RZID,N_RZLX,N_BMDM,N_YGGH,C_RZNR ......

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

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

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