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