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

What is the full meaning of dml?

0 Answers  


Can you explain full-text query in sql server?

0 Answers  


What is the difference between HAVING clause and the WHERE clause?

7 Answers  


How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  


What is cdc in sql server?

0 Answers  






Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  


Why is replication required on the sql server?

0 Answers  


What is user-defined function?

0 Answers  


What is instead of trigger sql server?

0 Answers  


How to set database to be read_only in ms sql server?

0 Answers  


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  


Categories