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
Explain filtered indexes?
What is the difference between migration and upgradation in sql server?
What are the diifferences between the ms sql server vs mysql?
What xml support does the sql server extend?
What is raid, and how it can influence database performance?
Explain “@@rowcount” and “@@error” in sql server?
What is logon trigger?
when you create a database how is it stored? : Sql server database administration
Can we insert data into view sql server?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
How to provide values to stored procedure parameters in ms sql server?
What is subquery in sql?
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?
List out the differences between the clustered index and non-clustered index in sql server?
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?