What are cursors?

Answer Posted / guest

Well cursors help us to do an operation on a set of data
that we retreive by commands such as Select columns from
table. For example : If we have duplicate records in a table
we can remove it by declaring a cursor which would check the
records during retreival one by one and remove rows which
have duplicate values.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are full-text indexes stored?

729


What is sql server replication? : sql server replication

692


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

736


How to find out the list schema name and table name for the database?

709


How to specify the collation for a character data type in ms sql server?

740






What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

744


What is ssl in sql server?

747


What is read uncmmited?

789


Give me a SQL Query to find out the second largest company?

922


can any body tell me how to know the password of current user in sql server

1778


What is the minimum recommended amount of ram for sql server 2012 enterprise?

688


Mention the differences between sql server and mysql.

680


Explain the stored procedure?

812


What happens to a trigger with multiple affected rows?

691


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

752