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

Explain filtered indexes?

741


What is the difference between migration and upgradation in sql server?

790


What are the diifferences between the ms sql server vs mysql?

888


What xml support does the sql server extend?

724


What is raid, and how it can influence database performance?

756






Explain “@@rowcount” and “@@error” in sql server?

722


What is logon trigger?

716


when you create a database how is it stored? : Sql server database administration

675


Can we insert data into view sql server?

716


Tell me the use of keyword with encryption. Create a store procedure with encryption?

747


How to provide values to stored procedure parameters in ms sql server?

717


What is subquery in sql?

734


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

763


List out the differences between the clustered index and non-clustered index in sql server?

700


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

678