create proc usp_select1
as
begin
select * from emp
exec usp_select2
end
--Waring:Cannot add rows to sysdepends for the current object because it depends
--on the missing object 'usp_select2'. The object will still be created.
create proc usp_select2
as
begin
select * from emp
exec usp_select1
end
--Command(s) completed successfully.
exec usp_select1
--Error:Msg 217, Level 16, State 1, Procedure usp_select2, Line 5
--Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
No comments:
Post a Comment