Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 19130 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 difference between commit and rollback when used in transactions?
What are the dmvs? : sql server database administration
When cursors are useful?
What are the advantages of policy management?
What is oltp (online transaction processing)?
What are types of scd? : sql server analysis services, ssas
How to encrypt data between dialogs?
How can you manage sql azure security?
How do I connect to sql server database?
What is ms sql server reporting services?
Explain sub-query?
Where in ms sql server is ’100’ equal to ‘0’?
Explain the functionalities that views support?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to declare a cursor with "declare ... Cursor" in ms sql server?
