Advantages and Disadvantages of Cursor?
Answer Posted / hiral bhatt
Dear All,
Cursor, its an object in SQL Server and the main advantages
of cursor is that whenevr we need to fetch records in row
by row Manner..
But using cursor, it itself is not a good concept, we have
another alternate for cursor like Temp Table.
Regards
Hiral Bhatt
Sr. Software Engg.
Is This Answer Correct ? | 43 Yes | 21 No |
Post New Answer View All Answers
Is INSTEAD OF trigger directly applicable to Table ?
How do I run a trace in sql server?
What is the need for indexing?
Different types of keys in SQL?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What purpose does the model database server?
What are the types of subscriptions in SQL Server replication?
List the different index configurations possible for a table?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is 1nf 2nf and 3nf?
What is the significance of null value and why should we avoid permitting null values?
How do you open a cluster administrator?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How many categories of data types used by sql server?