Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?


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

Post New Answer

More SQL Server Interview Questions

Alternative way to DetDate() function?

5 Answers  


List the types of recovery model available in sql server?

0 Answers  


What is difference between equi join and natural join?

0 Answers  


how can a database be repaired? : Sql server administration

0 Answers  


Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,






could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  


What is the recovery model?

0 Answers  


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  


How connect excel to sql server?

0 Answers  


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  


Can sql servers link to other servers like oracle?

0 Answers  


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  


Categories