What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 16842 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashish sehra
Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Which tcp/ip port does sql server run on? How can it be changed?
What is difference between group by and having?
Which sql server table is used to hold the stored procedure scripts?
Explain transaction server auto commit?
What is report server project?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to list all field names in the result set using mssql_field_name()?
Why do we use trigger?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Can you pass expressions to function parameters?
How to insert data into an existing table?
What is an example of a primary key?
How to delete existing triggers using "drop trigger"?
How would you use user_constraints table in DB?
Why would you call update statistics?
