Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Advantages and Disadvantages of Cursor?

Answer Posted / vivekanand

Merits: Row by Row Validations, good choice for small set of records

De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.

Cheers,Vivekanand

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to reaname table name without using sp_Rename in sql server..?

953


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

978


Explain the properties of sub-query in sql server?

966


Can you insert NULL in unique column?

1120


Name three of the features managed by the surface area configuration tool? : sql server security

958


How do I run sql server 2014?

952


How to find tables without indexes?

1052


What are the recovery models in sql server 2000?

937


How to throw custom exception in Stored Procedure?

1006


Explain syntax for viewing, dropping and disabling triggers?

912


What is in place upgrade in sql server?

1007


Do you know what is bit data type and whats the information that can be stored inside a bit column?

923


What is ssrs?

121


What is the difference between for trigger and after trigger?

1052


What is log cache in sql server?

1001