The Static Cursor – Makes a temporary copy of the data and stores in tempdb and any modifications on the base table do not reflected in data returned by fetches made by the cursor.
The Dynamic Cursor – Reflects all changes in the base table.
The Forward-only Cursor – specifies that cursor can only fetch sequentially from first to last.
The Keyset-driven – A Keyset is the set of keys that uniquely identifies a row is built in a tempdb.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
Types of cursors :
The Static Cursor – Makes a temporary copy of the data and stores in tempdb and any modifications on the base table do not reflected in data returned by fetches made by the cursor.
The Dynamic Cursor – Reflects all changes in the base table.
The Forward-only Cursor – specifies that cursor can only fetch sequentially from first to last.
The Keyset-driven – A Keyset is the set of keys that uniquely identifies a row is built in a tempdb.