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 mysql and sql server?
What is Dependency Injection and provide example?
how many type of indexing in database?
What is blocking and how would you troubleshoot it? : sql server database administration
Explain system rowset functions?
Explain try...catch with sql server?
Explain the difference between cross join and full outer join?
Describe in brief system database.
What are synonyms?
What is the difference between dbcc indexdefrag and dbcc reindex?
How do I run a trace in sql server?
Which are the olap features?
What are the differences between left join and inner join in sql server?
When does a workload on SQL Azure get throttled?
Tell me can we use custom code in ssrs?
