Vivek Sheth

Vivek Sheth

  • 757
  • 1k
  • 17.1k

Execute SQL Server stored procedures sequentially.

May 30 2016 2:02 AM
I have list of stored procedure.
 
spr_name1
spr_name2
spr_name3
spr_name4
spr_name5
 
Now i want to run this stored procedures sequentially. How can we implement this ?
code side or database side ?
 
One more condition is there. If any exception occurred at spr_name3 then result of spr_name1 and spr_name2 should be rollback.
 
It's obvious that spr_name4 and spr_name5 will not run after exception occured.
 
Need help in this scenario. 

Answers (7)