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
Is there any difference between primary key and unique with the not null condition?
What is sub query and its properties?
Why do you want to join software field as you have done your BE in Electronics?
Explain what is scheduled job and how to create it?
How many types of built in functions are there in sql server 2012?
How to enable tcp/ip protocol on a sql server?
Do I need a report server to run reports in my application?
What is reportserver and reportservertempdb ?
Explain system scalar functions?
Explain different types of self contained sub query?
How to create a stored procedure with a statement block in ms sql server?
Does a full backup include transaction log?
what is nonclustered index
What is the difference RDBMS and Graph Database?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
