Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How many types of Cursor in SQL SERVER?

Question Posted / amita awasthi


How many types of Cursor in SQL SERVER?..

Answer / anindya basu

There are four types of cursor in SQL Server which are:

a. Static
b. Dynamic
c. Forward Only, and
d. Keyset
Static keysets aren't sensitive to database changes and are scrollable.
Dynamic keysets are sensitive to database changes and are scrollable.
Forward only keysets aren't sensitive to database changes and allows only forward scrolling of data. There are 3 variants of Forward Only cursors viz. Forward Only Static, Forward Only Keyset, and Fast Forward. Fast Forward is the fastest of all cursors.
Keyset cursor supports movement from the first row to the last and vice-versa. It doesn't identify inserts but recognizes both updates and deletes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How can you find out how many rows returned in a cursor?

0 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  

How to store and query spatial data?

0 Answers  

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

What are subqueries in sql server? Explain its properties.

0 Answers  

Explain timestamp datatype?

0 Answers  

What is store procedure? When do you use?

0 Answers  

Why do we need different type of parameter?

0 Answers  

What is normalization and what are the advantages of it?

0 Answers  

Can we add an identity column to decimal datatype?

0 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories