Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Can we nest stored procedures and functions?
on 9/15/2010 |
| Views : 1731 | Status :
| Replies : 1
Write New Post
Un Answered Posts
In SQL Server, can we execute SP's inside the function and vice versa? If possible how many levels can we nest?
Reply with Attachment
In Sql Server 2005 or 2000, You can nest stored procedures or functions up to 32 levels.(Procedures inside procedures). And this counter is stored inside a function @@NESTLEVEL.(Current level of nesting).
Further, you can call functions direcltly inside a SP. But vice versa is not possible. But some people are claiming that this is possible through xp_cmdshell. I'm not sure about this and never tried.
Mark this as answer, if it is.....
, if this helps please
Mark As Answer
Login to post response
Can any one show to scroll a table horizontally and vertically
How to search records in text box after triggering enter button in angularjs
how to Convert XLSX (EXCEL) to XLS (EXCEL) without ms-office using c#
select checkbox in datalist with out select link
what scenario using code first or entity framework
How to Fix this Issue Permanently in Sql Server
How to Restrict following Records in sql server
What is The Use of Method Hiding In C# although we having method overriding ?