Advantages and Disadvantages of Cursor?

Answer Posted / sharjeel

Hi Friends,

Cursor is more useful programming concept. It is a Data
Type which is used to define multivalue variable. Because
with cursor we fetch more records from tables or rows and
store in a static variable.

After Fetching values in a varible we can use that for
compairing from other values or other cursor.

Regards
Sharjeel Khan
Software Engineer.

Is This Answer Correct ?    29 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Business Edition in SQL Azure?

88


Write a SQL command to insert and update only a particular field?

619


What is sql server profiler?

567


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1485


What is the difference between clustered and non-clustered indexes in ms sql server?

485






Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

512


Explain indexing and what are the advantages of it?

522


What is a partition function in sql server?

535


Why functions are used in sql server?

502


Explain cdc and sql injection?

545


How to list all field names in the result set using mssql_field_name()?

522


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

575


What is the maximum size of column in sql server?

503


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

582


How do I view views in sql server?

516