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