6 Replies Latest reply: Jan 3, 2013 3:14 AM by BluShadow RSS

    Call more than one stored procedure in a new stored procedure

    936666
      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!