Tuesday, October 1, 2013

is there any harm in calling stored procedure recusivlly.

It depends on how you need the operations to perform. For instance a SELECT statement will not allow you to use Stored Procedure however we can call a user defined function/system function in the SELECT statement.


The level of recursion limit or count is applied for both stored procedures as well as user defined functions. The choice is yours how do you want to access.




Regards, RSingh





No comments:

Post a Comment