---
title: "Explain the types of cursors in SQL server:"  
description: "Explain the types of cursors in SQL server:"  
author: "Anonymous User"  
published: 2019-09-24  
updated: 2020-09-16  
canonical: https://www.mindstick.com/interview/33635/explain-the-types-of-cursors-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# Explain the types of cursors in SQL server:

## 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.

## Answers

### Answer by Anonymous User

## 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.


---

Original Source: https://www.mindstick.com/interview/33635/explain-the-types-of-cursors-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.