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 a check constraint?

841


How can windows applications connect to sql servers via odbc?

788


What happens if you insert a duplicate key for the primary key column in ms sql server?

725


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

740


What is the new security features added in sql server 2014? : sql server security

753






Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

803


What is index, cluster index and nonclustered index?

685


How many levels of sp nesting is possible?

795


What is key set driven?

702


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1752


What is difference between delete & truncate commands?

728


How do I start sql server agent automatically?

690


What is Federation Root Database?

100


What is correlated subquery in sql server?

742


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

759