Sunday, March 25, 2012

Calling SP Inside the SP

hai guys
how should we have to cal the store procedure inside the same store procedure.
for Example
Create procedure A
as
Begin
Select * from mytable
execute A
end.
is this the correct oneyes that is correct.
but the level of nesting is 32 if u exceed this u will get this error:
"Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."|||Got an error object does not exists, while compiling. how to compile|||can u post the actual script ur using?
and does the table u r trying to access, exist in the database?

No comments:

Post a Comment