how can execute multiple procedures sql server

Accepted answer

Create Procedure USP_ExecuteMultipleSP @Param1 VARCHAR(10),

@Param2 VARCHAR(10),@Param3 VARCHAR(10),@Param4 VARCHAR(10),@Param5 VARCHAR(10)

,@Param6 VARCHAR(10),@Param7 VARCHAR(10),@Param8 VARCHAR(10)

AS

BEGIN

SET NOCOUNT ON;

EXEC USP_TEST1 @Param1

EXEC USP_TEST2 @Param2

EXEC USP_TEST3 @Param3

EXEC USP_TEST4 @Param4

EXEC USP_TEST5 @Param5

EXEC USP_TEST6 @Param6

EXEC USP_TEST7 @Param7

EXEC USP_TEST8 @Param8

END

EXEC USP_ExecuteMultipleSP (pass your 8 param)

+1

@pravat kumar I have 8 proc with param How exec all in one time

0

please elaborate your requirement.

0

exec ProcedureName ParamenterValue1,ParamenterValue2,ParamenterValue3

exec ProcedureName1 ParamenterValue1,ParamenterValue2,ParamenterValue3

exec ProcedureName2 ParamenterValue1,ParamenterValue2,ParamenterValue3

exec ProcedureName3 ParamenterValue1,ParamenterValue2,ParamenterValue3

+1

Do you want to execute One Procedure into another Procedure?

0