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


Please Help Members By Posting Answers For Below Questions

What are transactions and its controls?

619


Why are you getting errors when creating a new odbc dsn?

591


What is the default port for SQL Server over a firewall?

593


What are wait types?

588


What stored procedure would you use to view lock information?

530






What are different types of database indexes?

534


What are different replication agents and what's their purpose? : sql server replication

576


What is difference between index and primary key?

590


What are views used for?

620


Explain relational data?

550


What is the difference between a stored procedure and a user defined function?

547


What is the exact numeric data type in sql?

551


what is the difference between Delete and Truncate command in SQL

630


What is mean by dml?

542


Explain forward - only cursors?

521