Reg : Help on Transactions in SQL

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  September 23, 2013 at 11:49 pm

  #298140

  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

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  September 24, 2013 at 8:07 am

  #1652747

  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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/