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 purpose of the model database?
What is the difference between writing data to mirrored drives versus raid5 drives
How you can get the list of largest tables in a database?
What are the difference between clustered and a non-clustered index?
What does dml stand for?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Can we take the full database backup in log shipping?
Why do we use non clustered index?
Explain cdc and sql injection?
What are the five characteristics of good data?
What is the purpose of forms?
What is the process of normalization?
What is dbcc updateusage?
Can we store videos inside the sql server table?
What is measure group, measure? : sql server analysis services, ssas
