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

What is the native system stored procedure to execute a command against all databases?

1031


Can an automatic recovery be initiated by a user?

1018


What are the types of table?

980


Give a example to search fr a string in all stored procedure in sql server.

988


Explain the relational database management system (rdbms)?

1100


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1210


What is inner join in sql server joins?

1040


What are distinctive joins find as a part of sql?

953


Explain a differential backup?

1014


What is difference between drop truncate and delete?

1095


What are the different types of lock modes in sql server 2000?

949


How to implement service broker?

1011


What new data source types were added in ssrs 2014?

160


How to write a query with an inner join in ms sql server?

1049


Explain hostprotectionattribute in sql server 2005?

1039