Çë½ÌsqlserverÖÐÄÜ·ñÔÚÒ»¸öÊÂÎïÀïÃ濪ÊÂÎï
±ÈÈ磺 ÊÂÎï1 START ¡£¡£¡£¡£¡£¡£ ÊÂÎï2 START ²åÈëÒ»Õűí ÊÂÎï2 END ¡£¡£¡£¡£¡£¡£ È»ºó³ÌÐò±Àµô£¬ÊÂÎï1»Ø¹ö£¬²»¹ýÓÖÏëÌá½»ÊÂÎï2µÄÊý¾Ý¡£ ÊÂÎï1 END Óа취ʵÏÖÂð
d Ó¦¸ÃÊDz»ÐеÄÁË£¬ÕâÑù¾ÍÎ¥±³ÁËÊÂÎïµÄÒâÒåÁË¡£ ¿ÉÒÔÔÚÒ»¸öÏÔʽÊÂÎñÖаüº¬ÁíÒ»¸öÏÔʽÊÂÎñ£¨ÊÂÎñǶÌ×£©¡£ÔÚÏÔʾÊÂÎñÖУ¬Ã¿Ö´ÐÐÒ»¸ö BEGIN TRAN Óï¾ä¶¼»á¿ªÊ¼Ò»¸öеÄÊÂÎñ£¬ÊÂÎñÊý¶¼»á¼Ó 1£»Ã¿Ö´ÐÐÒ»¸ö COMMIT TRAN Óï¾äÊÂÎñÊý¶¼»á¼õ 1£¬µ«ÊÇÖ»ÓÐ×îÍâ²ãǶÌ×µÄ COMMIT TRAN Óï¾ä²Å»áÕæÕýÌá½»ÔÚËü֮ǰµÄËùÓÐÊÂÎñ£¬¶øÔÚÆäËû¸÷²ãǶÌ×É쵀 COMMIT TRAN Óï¾ä²¢²»ÕæÕýÌá½»±¾Ç¶Ì×µÄÊÂÎñ£»ÎÞÂÛÔÚÄÄÒ»²ãÊÂÎñÉÏÖ´ÐÐÒ»¸ö ROLLBACK TRAN Óï¾ä¶¼»á»Ø¹öÔÚËü֮ǰµÄËùÓÐÊÂÎñ£¬ÊÂÎñÊýΪ 0¡£ ¿ÉÒÔÔÚÊÂÎñÖÐʹÓà SAVE TRAN Óï¾ä£¬ÊµÏÖ²¿·Ö»Ø¹öÊÂÎñ——ÔÚÏÔʾÊÂÎñÖеÄÌض¨Î»ÖÃÌí¼Ó SAVE TRAN savepoint Óï¾ä£¬ÔÚÐèҪʱ¿ÉÒÔʹÓà ROLLBACK TRAN savepoint Óï¾ä½«ÊÂÎñ»Ø¹öµ½ savepoint λÖᣠÊÂÎñÊÇ¿ÉÒÔǶÌ×µÄ begin tran begin tran select * from sysobjects commit tran select 1/0 commit tran up ¿ÉÒÔÓÃÊÂÎñ±êÖ¾°É Õâ¸öÎÊÌâ¼ÌÐø°ïUP ÊÂÎï1»Ø¹ö£¬ÊÂÎï2¿Ï¶¨»á»Ø¹ö. ÒýÓà ÊÂÎï1»Ø¹ö£¬ÊÂÎï2¿Ï¶¨»á»Ø¹ö. KGÐÖ ¿É²»¿ÉÒÔÔÙÊÂÎñ2 µÄ
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç select * from table where contect('sdfsd',sdf) and ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿ ¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐʲôÇø±ð? ´ó¼Ò˵Ïêϸһµã ²»Ã÷°×~~~ Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡ Óöþ½øÖÆ´æ·ÅËãÁË ²»Ã÷°×£¬ÄÜ×Ðϸ ......
ÔÚmysqlÀïÓжÁËø дËø ÊÇÕâÑùÉèÖÃµÄ lock tables a write££££££Ð´Ëø ------ÄãµÄsqlÓï¾ä unlock tables ÏëÖªµÀ ÔÚsqlserver2005ÀïÓÐûÓжÔÓ¦µÄÓï¾äд£¿ £¨Ò²¾ÍÊÇ Èçº ......