Post reply

how to secuence stored_proc?

  • January 4, 2005 at 4:20 am

    #86194

    Hi, its possible to do that a stored_proc not execute while the previous proc has not finished?

    thanks

     

  • January 4, 2005 at 7:21 am

    #535771

    Are you wanting to execute a stored procedure while another one is running, execute a stored procedure from within another stored procedure, or have a stored procedure execute after the first one is completed?

    K. Brian Kelley
    @kbriankelley

  • January 4, 2005 at 7:42 am

    #535776

    have a stored procedure execute after the first one is completed

  • January 5, 2005 at 6:44 am

    #535966

    You'd need something like this :

    CREATE PROCEDURE [dbo].[ProcTest]

    AS

    Exec dbo.Proc1

    Exec dbo.Proc2

    GO

    Proc2 will execute once proc1 is done running.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply