Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.?
- 2 Answers
- 17789 Views
- I also Faced
- E-Mail Answers
Answer Posted / lipsa
If a procedure calls itself it is called recursive.
Like if we are calculating the factorial of a number
writing a stored procedure,then there will be recursive
calling of the procedure.
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
What are statistics?
Define tempdb database?
What is difference between view and materialized view?
What is dirty read?
What is set nocount on?
What is scrollable cursor?
Where to find ntwdblib.dll version 2000.80.194.0?
What is sqlcmd?
If a table does not have a unique index, can a cursor be opened on it?
What is scheduled job and how to create it?
What is an active database?
Define normalisation?
What is sql server management studio? : sql server management studio
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Tell me in brief how sql server enhances scalability of the database system?
