8:17 AM
Deep Dey
Maximum Level of Nesting in SQL Server Stored Procedure
A Maximum of 32 levels of Nesting is allowed in SQL Server Stored Procedure. When the maximum of 32 is exceeded, the transaction is terminated.
Select @@NestLevel
Returns the nesting level of the current stored procedure execution (initially 0) on the local server
Keywords: @@NestLevel, Maximum Level of Nesting
A Maximum of 32 levels of Nesting is allowed in SQL Server Stored Procedure. When the maximum of 32 is exceeded, the transaction is terminated.
Select @@NestLevel
Returns the nesting level of the current stored procedure execution (initially 0) on the local server
Keywords: @@NestLevel, Maximum Level of Nesting
0 comments:
Post a Comment