Wednesday, August 22, 2012

GO statement inside a transaction


PROBLEM:
Can I use GO statement inside a transaction?

SOLUTION:
GO is just a command to the Client SQL program (Query Analyzer, SSMS, etc.) to terminate the current batch and execute it. GO does not terminate the current session or process and transactions are session-scoped entities. So, transactions are not commited or rollbacked when a GO is encountered

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

No comments:

Post a Comment