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
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