Nipun Tomar
What are cursors?
By Nipun Tomar in SQL Server on Jul 12 2006
  • Manoj Kumar Duraisamy
    Dec, 2016 30

    Implicit cursorsThese are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed. They are also created when a SELECT statement that returns just one row is executed. Explicit cursorsThey must be created when you are executing a SELECT statement that returns more than one row. Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row. When you fetch a row the current row position moves to next row.Both implicit and explicit cursors have the same functionality, but they differ in the way they are accessed.

    • 0
  • Nipun Tomar
    Jul, 2006 12

    Well cursors help us to do an operation on a set of data that we retreive by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retreival one by one and remove rows which have duplicate values.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS