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
What are transactions and its controls?
Why are you getting errors when creating a new odbc dsn?
What is the default port for SQL Server over a firewall?
What are wait types?
What stored procedure would you use to view lock information?
What are different types of database indexes?
What are different replication agents and what's their purpose? : sql server replication
What is difference between index and primary key?
What are views used for?
Explain relational data?
What is the difference between a stored procedure and a user defined function?
What is the exact numeric data type in sql?
what is the difference between Delete and Truncate command in SQL
What is mean by dml?
Explain forward - only cursors?