Thursday, 7 April 2011

Calling first stored proc in 2nd stored proc and calling 2nd stored proc in first stored proc?



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