Skip to Content
0
Aug 24, 2016 at 11:30 PM

Nested Stored Procedures

351 Views

Does anyone knows about best practices for nested calls in store procedures?

An example:

SP_1(PARAM1)

{

Do something;

}

SP_2(PARAM2)

{

SP_1(PARAM2);

}

SP_3(PARAM3,PARAM4)

{

SP_2(PARAM3);

SP_2(PARAM4);

}

is or isnt a good practice?

THANKS.