Answer Posted / selvaraj.v
SQL SERVER 2000,
Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis.
Cursor helps to update, add, select, remove on a row by row
basis on a table.
A cursor is a mechanism by which you can assign a name to
a "select statement" and manipulate the information within
that SQL statement.
We've categorized cursors into the following topics:
1.Declare a Cursor
2.OPEN Statement
3.FETCH Statement
4.CLOSE Statement
5.Cursor Attributes (%FOUND, %NOTFOUND, etc)
6.SELECT FOR UPDATE Statement
7.WHERE CURRENT OF Statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why are you getting errors when creating a new odbc dsn?
What is coalesce in sql server?
What is lookup override?
How to list all user names in a database?
What gets stored inside msdb database?
What does it mean to normalize data?
How to provide login information for a new odbc dsn?
Can you explain the disadvantages/limitation of the cursor?
What is 'Join' and explain its various types.
Can primary key be null?
How to download and install sql server 2005 books online?
Do you know what is lock escalation?
What do you understand by the analysis services in sql server?
How can you ensure that the database and sql server based application perform well?
What are the joins in sql server? : sql server database administration
