Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reg : Help on Transactions in SQL Expand / Collapse
Author
Message
Posted Monday, September 23, 2013 11:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 135, Visits: 373
Hi There,

I have some doubts on transactions. Following is my problem & I'm intended to go with transactions .

I have a stored procedure. If it ran successfully then no problem, in case of any interruption like killing the SP or some error occurred while in the middle of the run then I have to rollback all the things which was done by sp so far.

So I'm intended to go with transactions .

If I create transaction it will make the roll back easy to me.

1. I need code which will automatically rollback when any error while in the run of whole
SP.
2. What would happen if the sp killed forcibly .i.e., will transaction commuted or rolled back ?

Thanks in Advance
Post #1497656
Posted Tuesday, September 24, 2013 8:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:21 PM
Points: 13,083, Visits: 11,918
Look at try/catch.

http://technet.microsoft.com/en-us/library/ms175976.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1497877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse