Nesting level of a stored procedures execution is stored in the _________ function.
A. @@NEST
B. @@NESTLEVEL
C. @@LEVEL
D. None of the mentioned
Answer:A
Nesting level of a stored procedures execution is stored in the _________ function.
A. @@NEST B. @@NESTLEVEL C. @@LEVEL D. None of the mentioned
Explanation:When @@NESTLEVEL is executed within a Transact-SQL string, the value returned is 1 + the current nesting level.