Advantages and Disadvantages of Cursor?

Answer Posted / fusion

You can perform operation on each row.

Disadv. - Consumes more resources

Is This Answer Correct ?    55 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between count (*) and count 1?

586


What do you need to connect php to sql server?

637


How to copy the tables, schema and views from one sql server to another?

640


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

639


What is row_number()?

694






Explain raiserror in sql server?

659


What is deploy, process and build? : sql server analysis services, ssas

656


Do you know the different ddl commands in sql?

670


What does sql server mean?

612


What is the difference between ‘having’ clause and a ‘where’ clause?

651


What is the use of custom fields in report?

642


How to call a function from a stored procedure in SQL Server ?

643


What is cte (common table expression)?

679


what types of replication are supported in sql server? : Sql server database administration

559


Create and insert into temp table in sql server?

680