TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vivek Sheth
809
1k
17.8k
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.
Reply
Answers (
7
)
Crystal Reporting Showing Wrong Values and SQL server Shows
Unable to read date '1900-01-01' in sql server