Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
Execute SQL Server stored procedures sequentially.
Vivek Sheth
May 30 2016 2:02 AM
661
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Crystal Reporting Showing Wrong Values and SQL server Shows
Unable to read date '1900-01-01' in sql server