Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 18842 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 are database files and filegroups? : Sql server database administration
If the job running very slow what is the action you do
What is application role in sql server database security? : sql server security
What is the use of floor function in sql server?
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
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are various ways to enhance the ssrs report?
Explain the use of containers in ssis?
Why functions are used in sql server?
How to return the date part only from a sql server datetime datatype?
How to handle error or exception in sql?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Can two tables share a primary key?
What do you understand by a view? What does the with check option clause for a view do?
How to include text values in sql statements?
