Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 19177 Views
- I also Faced
- E-Mail Answers
Answer Posted / lekhraj deshmukh
Cursor:-Cursor is used for fetching the ror by row data from
tables.
Note:-Cursor is the only datatypa that can not be used in
table creation.
When will be use cursor need to perform following steps:-
1)decalere a cursor
2) open a cursor
3)fetch the cursor
4)close the cursor
5)deallocate the cursor
Types of cursor:-
1)API cursor
2)client cursor
3)sql server cursor
| Is This Answer Correct ? | 9 Yes | 10 No |
Post New Answer View All Answers
What is SQL Azure Data sync?
What is extended stored procedures?
When we should use and scope of @@identity?
What are indexes in sql?
What is the difference between update lock and exclusive lock?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Why de-normalization required?
Explain what are page splits? : SQL Server Architecture
what are isolation levels? : Sql server database administration
How do I create an extended event in sql server?
Define Unique Key?
What the difference between UNION and UNIONALL?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is lookup override?
