What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?


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

Post New Answer

More SQL Server Interview Questions

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  


What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  


What is difference between stored procedure and user defined function?

0 Answers  


How do I start sql server agent automatically?

0 Answers  


Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,






1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  


What is bcp? When does it used?

0 Answers  


How would you choose between a clustered and a non-clustered index?

0 Answers  


What is the maximum size of a row in sql server?

0 Answers  


How can you see what type of locks used?

1 Answers  


When is the use of update_statistics command?

0 Answers  


What is DAC? what is the use of it?

1 Answers   Wipro,


Categories