why we use cursor?
Answer Posted / manoj kumar singh
When we want to update row depending on certain criteria. we
will loop through all rows and update data accordingly.
There's where cursors come in to picture.
Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Comment,Datatypes are unlimited
What is 3nf normalization form?
Do you know data definition language, data control language and data manipulation language?
What is a schema in ms sql server 2005?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is the use of floor function in sql server?
After removing a table from database, what other related objects have to be dropped explicitly?
How to use order by with union operators in ms sql server?
Do you know sql server 2008 backup compression?
System requirements for sql server 2005 express edition?
Please illustrate physical database architecture? : SQL Server Architecture
How to return the second 5 rows in ms sql server?
Can we add an identity column to decimal datatype?