1000copy@gmail.com

»¶Ó­À´µ½1000copy@gmail.com>>¡¡¡¡ | Ê×Ò³ ×ÊÔ´ÖÐÐÄ | ÔĶÁ | Python | רÀ¸Ñ§Ï°technet ϵÁÐ¿Î³Ì | ¸öÈËÄ¿±ê | ¼ÒÈË | ÍæÀÖ | ¼¼Êõ | ITPUBÂÛ̳

sql2005й¦ÄÜ£­Òì³£´¦Àí

·¢±íÈË:1000copy | ·¢±íʱ¼ä: 2006ÄêÁùÔÂ28ÈÕ, 22:34

sql2005й¦ÄÜ£­Òì³£´¦Àí

¡¡4. try ... catch

¡¡¡¡SQL Server 2000ûÓÐÒì³££¬T-SQL±ØÐëÖðÐмì²é´íÎó´úÂ룬¶ÔÓÚϰ¹ßÁËtry catch³ÌÐòÔ±£¬2005ÊDz»ÊǸü¼ÓÇ×ÇУº

SET XACT_ABORT ON -- ´ò¿ª try¹¦ÄÜ
BEGIN TRY
begin tran
insert into Orders(CustomerId) values(-1)
commit tran
print 'commited'
END TRY
BEGIN CATCH
rollback
print 'rolled back'
END CATCH

·¢±íÆÀÂÛ

±êÌâ

ÔÚ´ËÌí¼ÓÆÀÂÛ

³Æºô

ÓÊÏ䵨ַ£¨¿ÉÑ¡£©

¸öÈËÖ÷Ò³£¨¿ÉÑ¡£©




Valid XHTML 1.0 Strict and CSS. Powered by pLog
Design by Blog.lvwo.com