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
how can a database be repaired? : Sql server administration
Can sub report data source be different from that of the parent report?
Explain what are the different index configurations a table can have?
Is it ok to shrink transaction log?
What is self join in sql server joins?
How to get the definition of a user defined function back?
What is an expression in ms sql server?
What is encryption key?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain the benefits of user-defined functions?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is sql server transaction log file?
Explain what are magic tables in sql server?
Explain logical operators in sql server?
How to check status of stored procedure in sql server?
