mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
update user set name='55' where id=1£¨´ËÊ±Ëø×¡µÈ´ýA£©
update user set name='66' where id=1£¨Õâ¸öʱºò»á³öÏÖËÀËø)
¸üгɹ¦
Èç¹û»»³Éɾ³ýµÄ»°¾Í²»»á³öÏÖËÀËø×´Ì¬£¬B»áµÈ´ýAÌá½»ºóɾ³ý
Èç¹û½«select»»ÎªÅÅËûËøµÄ»°B»áµÈ´ýAÌá½»ºó¸üÐÂ
ÊéÖнâÊÍÊÇBÓÉÓÚÎÞ·¨»ñÈ¡¹²ÏíËøËùÒÔ·ÅÈë¶ÓÁУ¬A´ËʱupdateÓë¶ÓÁеÄBµÄupdate³åÍ»Ôì³ÉËÀËø£¬
ÎÒÈÏΪµÄÊÇBÓ¦¸ÃÔÚAÌá½»ºó²Å½øÐиüвÙ×÷£¬´ËʱΪʲô²¢Ã»ÓÐÌá½»¾Í»á·¢Éú³åÍ»ÄØ£¿¶øselectÉèΪÅÅËûËø¾Í²»»á
¹²ÏíËøÓëÅÅËûËø»¹ÓÐʲôÔÀíÄØ£¿Ð»Ð»
Èç¹ûÊÇsql server,Ôò²Î¿¼ÏÂÃæµÄһЩÎÄÕÂ.
SQL code:
1 ÈçºÎËøÒ»¸ö±íµÄijһÐÐ
A Á¬½ÓÖÐÖ´ÐÐ
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
begin tran
select * from tablename with (rowlock) where id=3
waitfor delay '00:00:05'
commit tran
BÁ¬½ÓÖÐÈç¹ûÖ´ÐÐ
update tablename set colname='10' where id=3 --ÔòÒªµÈ´ý5Ãë
update tablename set colname='10' where id<>3 --¿ÉÁ¢¼´Ö´ÐÐ
2 Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±í
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......