Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain in brief how sql server enhances scalability of the database system?

0 Answers  


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  


Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  


What are the indexes in sql server?

0 Answers  


What are the differences between having and where clause.

0 Answers  






What is set nocount on?

0 Answers  


What is a bit datatype?

0 Answers  


How self join is different from outer join?

0 Answers   Blue Star,


Explain indexes disadvantages?

0 Answers  


Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,


We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  


How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,


Categories