what is curser.

Answer Posted / vijay

The set of rows is returned by SELECT statementb by using
WHERE clause or not. In our application can not work
EFFICIENTLY to this result set. If we want to
access/process the entire block or row or fields or it
different kind of property, we need the mechanism. This
mechanism is called CURSOR.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to recompile stored procedure at run time?

575


How global temporary tables are represented and its scope?

561


What is normalization and what are the advantages of it?

531


Explain about extended stored procedure?

501


What is 2nf in normalization?

547






What are the components of sql server service broker?

520


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1534


How to declare a cursor with "declare ... Cursor" in ms sql server?

580


What are the system database in sql server 2008?

590


How do you size a resultset?

512


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

564


Why do you want to join software field as you have done your BE in Electronics?

1715


How do I find my localdb version?

504


Explain use of expression builder.

575


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

600