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

Do you know what is openxml in sql server?

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

What is oltp (online transaction processing)?

0 Answers  

Is it possible in sql table to have more than one foreign key?

0 Answers  

How to use linked server?

0 Answers  

What is the process of normalization?

0 Answers  

What is Schema in Database?

1 Answers   Cap Gemini,

what is database replication? : Sql server database administration

0 Answers  

How to provide login information for a new odbc dsn?

0 Answers  

What is the difference between varchar and nvarchar types?

1 Answers  

What is an execution plan? When would you use it?

0 Answers  

What is transact-sql ddl trigger?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories