Committing Transaction

Posted by Costa on Stack Overflow See other posts from Stack Overflow or by Costa
Published on 2010-03-28T12:28:11Z Indexed on 2010/03/28 12:33 UTC
Read the original article Hit count: 240

Filed under:
|
|

Hi

http://msdn.microsoft.com/en-us/library/ms189797.aspx

In this link they are committing a transaction within catch clause IF (XACT_STATE()) = 1, I don't get it, if there is an error why they are committing it? even if the problem in select statement and there is no big deal committing it, why don't just roll it back.

Thanks

© Stack Overflow or respective owner

Related posts about tsql

Related posts about sql-server