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
What are temporal tables in sql server 2016?
Describe how to use linked server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How do you check sql server is up and running?
What is a db view?
What are the types of lock supported by ?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to skip remaining statements in a loop block using continue statements?
Explain few examples of stored procedure over triggers?
What happens if null values are involved in comparison operations?
Do you know what is difference between stored procedure and user defined function?
How to find the list of fixed hard drive and free space on server?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is set nocount on and what is set nocount off?
What is the importance of a recovery model?