mssqlÀïÊÂÎñµÄÏê½â
ÕûÀíתÌù
Ò»¡¢ÊÂÎñµÄÊôÐÔ
¡¡¡¡ÊÂÎñ¾ßÓÐacidÊôÐÔ:¼´ atomicÔ×ÓÐÔ, consistentÒ»ÖÂÐÔ, isolated¸ôÀëÐÔ, durableÓÀ¾ÃÐÔ
¡¡¡¡Ô×ÓÐÔ£ºÊÂÎñÓ¦×÷Ϊһ¸ö¹¤×÷µ¥Ôª,ÊÂÎñ´¦ÀíÍê³É£¬ËùÓеŤ×÷Ҫô¶¼ÔÚÊý¾Ý¿âÖб£´æÏÂÀ´£¬ÒªÃ´ÍêÈ«»Ø¹ö£¬È«²¿²»±£Áô
¡¡¡¡Ò»ÖÂÐÔ£ºÊÂÎñÍê³É»òÕß³·Ïúºó£¬¶¼Ó¦¸Ã´¦ÓÚÒ»ÖµÄ״̬
¡¡¡¡¸ôÀëÐÔ£º¶à¸öÊÂÎñͬʱ½øÐУ¬ËüÃÇÖ®¼äÓ¦¸Ã»¥²»¸ÉÈÅ.Ó¦¸Ã·ÀÖ¹Ò»¸öÊÂÎñ´¦ÀíÆäËûÊÂÎñÒ²ÒªÐ޸ĵÄÊý¾Ýʱ£¬²»ºÏÀíµÄ´æÈ¡ºÍ²»ÍêÕûµÄ¶ÁÈ¡Êý¾Ý
¡¡¡¡ÓÀ¾ÃÐÔ£ºÊÂÎñÌá½»ÒÔºó£¬Ëù×öµÄ¹¤×÷¾Í±»ÓÀ¾ÃµÄ±£´æÏÂÀ´
¶þ¡¢ÊÂÎñ²¢·¢´¦Àí»á²úÉúµÄÎÊÌâ
¡¡¡¡¶ªÊ§¸üУºµ±Á½¸ö»ò¶à¸öÊÂÎñÑ¡ÔñͬһÐУ¬È»ºó»ùÓÚ×î³õÑ¡¶¨µÄÖµ¸üиÃÐÐʱ£¬»á·¢Éú¶ªÊ§¸üÐÂÎÊÌ⡢ÿ¸öÊÂÎñ¶¼²»ÖªµÀÆäËüÊÂÎñµÄ´æÔÚ¡£×îºóµÄ¸üн«ÖØдÓÉÆäËüÊÂÎñËù×öµÄ¸üУ¬Õ⽫µ¼ÖÂÊý¾Ý¶ªÊ§¡£
¡¡¡¡Ôà¶Á£ºµ±µÚ¶þ¸öÊÂÎñÑ¡ÔñÆäËüÊÂÎñÕýÔÚ¸üеÄÐÐʱ£¬»á·¢ÉúδȷÈϵÄÏà¹ØÐÔÎÊÌâ¡£ µÚ¶þ¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÊý¾Ý»¹Ã»ÓÐÈ·Èϲ¢ÇÒ¿ÉÄÜÓɸüдËÐеÄÊÂÎñËù¸ü¸Ä¡£
¡¡¡¡²»¿ÉÖظ´¶Á£ºµ±µÚ¶þ¸öÊÂÎñ¶à´Î·ÃÎÊͬһÐжøÇÒÿ´Î¶ÁÈ¡²»Í¬µÄÊý¾Ýʱ£¬»á·¢Éú²»Ò»ÖµķÖÎöÎÊÌâ¡£²»Ò»ÖµķÖÎöÓëδȷÈϵÄÏà¹ØÐÔÀàËÆ£¬ÒòΪÆäËüÊÂÎñÒ²ÊÇÕýÔÚ¸ü¸ÄµÚ¶þ¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÊý¾Ý¡£ È»¶ø£¬ÔÚ²»Ò»ÖµķÖÎöÖУ¬µÚ¶þ¸öÊÂÎñ¶ÁÈ¡µÄÊý¾ÝÊÇÓÉÒѽøÐÐÁ˸ü¸ÄµÄÊÂÎñÌá½»µÄ¡£¶øÇÒ£¬²»Ò»ÖµķÖÎöÉæ¼°¶à´Î£¨Á½´Î»ò¸ü¶à£©¶ÁȡͬһÐУ¬¶øÇÒÿ´ÎÐÅÏ¢¶¼ÓÉÆäËüÊÂÎñ¸ü¸Ä£»Òò¶ø¸ÃÐб»·ÇÖظ´¶ÁÈ¡¡£
¡¡¡¡»ÃÏñ¶Á£ºµ±¶ÔijÐÐÖ´ÐвåÈë»òɾ³ý²Ù×÷£¬¶ø¸ÃÐÐÊôÓÚij¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÐеķ¶Î§Ê±£¬»á·¢Éú»ÃÏñ¶ÁÎÊÌâ¡£ ÊÂÎñµÚÒ»´Î¶ÁµÄÐз¶Î§ÏÔʾ³öÆäÖÐÒ»ÐÐÒѲ»¸´´æÔÚÓÚµÚ¶þ´Î¶Á»òºóÐø¶ÁÖУ¬ÒòΪ¸ÃÐÐÒѱ»ÆäËüÊÂÎñɾ³ý¡£Í¬Ñù£¬ÓÉÓÚÆäËüÊÂÎñµÄ²åÈë²Ù×÷£¬ÊÂÎñµÄµÚ¶þ´Î»òºóÐø¶ÁÏÔʾÓÐÒ»ÐÐÒѲ»´æÔÚÓÚÔʼ¶ÁÖС£
Èý¡¢ÊÂÎñ´¦ÀíÀàÐÍ
¡¡¡¡×Ô¶¯´¦ÀíÊÂÎñ£ºÏµÍ³Ä¬ÈÏÿ¸öt£sqlÃüÁÊÇÊÂÎñ´¦Àí ÓÉϵͳ×Ô¶¯¿ªÊ¼²¢Ìá½»
¡¡¡¡ÒþʽÊÂÎñ£ºµ±ÓдóÁ¿µÄddl ºÍdmlÃüÁîÖ´ÐÐʱ»á×Ô¶¯¿ªÊ¼£¬²¢Ò»Ö±±£³Öµ½Óû§Ã÷È·ÌύΪֹ£¬Çл»ÒþʽÊÂÎñ¿ÉÒÔÓÃset implicit_transactions.ΪÁ¬½ÓÉèÖÃÒþÐÔÊÂÎñģʽ.µ±ÉèÖÃΪ on ʱ£¬set implicit_transactions ½«Á¬½ÓÉèÖÃΪÒþÐÔÊÂÎñģʽ¡£µ±ÉèÖÃΪ off ʱ£¬ÔòʹÁ¬½Ó·µ»Øµ½×Ô¶¯Ìá½»ÊÂÎñģʽ
¡¡¡¡Óû§¶¨ÒåÊÂÎñ£ºÓÉÓû§À´¿ØÖÆÊÂÎñµÄ¿ªÊ¼ºÍ½áÊø ÃüÁîÓÐ: begin tran, commit tran,rollback tran ÃüÁî
¡¡¡¡·Ö²¼Ê½ÊÂÎñ£º¿çÔ½¶à¸ö·þÎñÆ÷µÄÊÂÎñ³ÆΪ·Ö²¼Ê½ÊÂÎñ,sql server ¿ÉÒÔÓÉdtc microsoft dist
Ïà¹ØÎĵµ£º
sql´æ´¢¹ý³Ì½Ì³Ì
[ËѼ¯ÕûÀí]sql´æ´¢¹ý³ÌÍêÈ«½Ì³Ì
Ŀ¼
1.sql´æ´¢¹ý³Ì¸ÅÊö
2.SQL´æ´¢¹ý³Ì´´½¨
3.sql´æ´¢¹ý³Ì¼°Ó¦ÓÃ
4.¸÷ÖÖ´æ´¢¹ý³ÌʹÓÃÖ¸ÄÏ
5.ASPÖд洢¹ý³Ìµ÷ÓõÄÁ½ÖÖ·½Ê½¼°±È½Ï
6.SQL´æ´¢¹ý³ÌÔÚ.NETÊý¾Ý¿âÖеÄÓ¦ÓÃ
7.ʹÓÃSQL´æ´¢¹ý³ÌÒªÌرð×¢ÒâµÄÎÊÌâ
1.sql´æ´¢¹ý³Ì¸ÅÊö
ÔÚ´óÐÍÊý¾Ý¿âϵͳÖУ¬´æ´ ......
Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......
²éѯÓï¾äÖ»ÒªÕâÑùд,¾Í¿ÉÒÔËæ»úÈ¡³ö¼Ç¼ÁË
SQL="Select top 6 * from Dv_bbs1 where isbest = 1 and layer = 1 order by newID() desc"
ÔÚACCESSÀï
SELECT top 15 id from tablename order by rnd(id)
SQL Server£º
Select TOP N * from TABLE Order By NewID()
Access£º
Select TOP N * from TABLE Order By Rnd(ID ......
Sql2005ÖÐʹÓÃow_number() partition½øÐзÖ×éʵÑ飬
SQL£º
select * from stu
select id,row_number() over (partition by snm order by id) from stu
½á¹û£º
id snm
----------------
111 111V
111 111W
222 222N
333 3123
444 3123
555 3123
666 3232
777 3232
--·Ö×éºóµÄ½á¹û
id &n ......
php½Ì³Ì µ÷ÓÃmssql´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ
ÓÃmssql_initÓï¾äÓÃÓÚ³õʼ»¯´æ´¢¹ý³Ì£¬¶øºóµ÷ÓÃmssql_bindÓï¾äÖ¸¶¨´æ´¢¹ý³Ì²ÎÊý£¬×îºóµ÷ÓÃmssql_executeÖ´Ðд洢¹ý³Ì¡£
*/
//Á¬½ÓmssqlÊý¾Ý¿â½Ì³Ì·þÎñÆ÷
$link = mssql_connect("127.0.0.1", "sa", "sa") or die("Can't connect sql server");
mssql_sele ......