Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

stored procedure

hello,
How can I make a stored procedure that hold many other stored procedures.Infact I just want to execute one stored procedure and other procedure in it will automatically execute.
thank you

Comments

  • aarunlalaarunlal Member Posts: 95
    Using "exec" command u can execute other stored procedures.
    Eg.

    Create procedure test
    (
    )
    as
    begin
    .... statements .....
    exec test1 // executing the other stored procedure.
    .... statements .....
    end

    thanks
    Arunlal

    : hello,
    : How can I make a stored procedure that hold many other stored procedures.Infact I just want to execute one stored procedure and other procedure in it will automatically execute.
    : thank you
    :

  • tanveer haidertanveer haider Member Posts: 37
    Thank you very much
    tanveer haider

    : Using "exec" command u can execute other stored procedures.
    : Eg.
    :
    : Create procedure test
    : (
    : )
    : as
    : begin
    : .... statements .....
    : exec test1 // executing the other stored procedure.
    : .... statements .....
    : end
    :
    : thanks
    : Arunlal
    :
    : : hello,
    : : How can I make a stored procedure that hold many other stored procedures.Infact I just want to execute one stored procedure and other procedure in it will automatically execute.
    : : thank you
    : :
    :
    :

Sign In or Register to comment.