Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 19498 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 do mean by xml datatype?
Can you force a query to use a specific index?
What are four major operators that can be used to combine conditions on a where clause?
What is an execution plan?
How do I create a stored procedure in dbml?
can we have a nested transaction? : Sql server database administration
how you can list all the tables in a database?
What is the template in sql?
What are the new security features added in sql server 2012? : sql server security
Define model database?
Difference between 2NF &3NF ?
What is DCL?
Where are sql server user names and passwords stored in sql server?
What does nvl stand for?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
