This discussion is archived
6 Replies Latest reply: Jan 3, 2013 1:14 AM by BluShadow RSS

Call more than one stored procedure in a new stored procedure

936666 Newbie
Currently Being Moderated
Hi,

Execute sp1 param1...param6

Execute sp2 param1...param8

Execute sp3 param1...param4

All these stored procedures deals with insert/updated transactions
i need to create a new stored procedure to execute all this in a single stored procedure
which will be something like

create procedure sp4(param1...param8)
as
begin
Execute sp1 param1...param6
rollback if any error
Execute sp2 param1...param8
rollback if any error
Execute sp3 param1...param4
rollback if any error
end;

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points