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

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

What are the types of resultset?

0 Answers  

What is tempdb database? : SQL Server Architecture

0 Answers  

How to create a local temporary stored procedure?

0 Answers  

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

What sql server means?

0 Answers  

Can we add a cpu to sql server?

0 Answers  

What is pivot and unpivot?

0 Answers  

What is stored procedure in SQL..??

2 Answers  

For more SQL Server Interview Questions Click Here
Categories