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

What are temporal tables in sql server 2016?

483


Describe how to use linked server?

549


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

600


How do you check sql server is up and running?

516


What is a db view?

520






What are the types of lock supported by ?

614


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5506


How to skip remaining statements in a loop block using continue statements?

547


Explain few examples of stored procedure over triggers?

526


What happens if null values are involved in comparison operations?

550


Do you know what is difference between stored procedure and user defined function?

616


How to find the list of fixed hard drive and free space on server?

575


in the physical file layout, where should the transaction log be stored in relation to the data file?

538


What is set nocount on and what is set nocount off?

517


What is the importance of a recovery model?

615