July 11, 2012 at 2:56 pm
In the store procedure there are about 10 steps (update 10 tables) need to be done. If any step get an error will roll back.
The problem is exec this sp only needs less one second.
How to test a store procedure using transaction?
July 11, 2012 at 3:34 pm
adonetok (7/11/2012)
In the store procedure there are about 10 steps (update 10 tables) need to be done. If any step get an error will roll back.The problem is exec this sp only needs less one second.
How to test a store procedure using transaction?
Explanation is a bit vague but if there are no transactions inside the proc you can just wrap your call with a transaction.
begin transaction
exec YourProc
rollback transaction
If however you have a transaction inside your proc you need to find another way. Why not put this on a test box and bang on it. You have to test it in a test environment before it goes live anyway right???
_______________________________________________________________
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/
July 11, 2012 at 3:52 pm
Have a read through this article on how transactions work to make sure you get what you expect.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply