Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the difference between a clustered index and a non-clustered index?
Can you please explain the difference between function and stored procedure?
What do you mean by acid?
Does the order of columns in update statements matter?
What is triggers in ms sql server?
How to assign new column names in a view?
What are the characteristics of modern DBMS?
What are key constraints?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the cartesian product of the table?
what is checksum in sql server.........???
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How data can be copied from one table to another table?
What is bookmark link in ssrs?
what is a correlated sub-query? : Sql server database administration
