What is a cursor in SQL Server 2000 and their types?
Answer Posted / sd
Cursors allow row-by-row prcessing of the resultsets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven
| Is This Answer Correct ? | 30 Yes | 7 No |
Post New Answer View All Answers
Why I am getting this error when dropping a database in ms sql server?
What is compound operators?
Name few of the dcl commands in sql?
What is the difference between mysql and mysqli?
Can you please explain the difference between primary keys and foreign keys?
What are the advantages of the mirroring?
State the difference between union and union all?
How do you create an execution plan?
What is used to replicate sessions between instances in coldfusion clusters?
What is the difference between stored procedure and user defined functions?
How to loop through returning rows?
Find nth lowest salary or get nth lowest salary?
What is acid properties?
What do you understand by triggers and mention the different types of it?
What is the function of sql server agent windows service?