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...

How to avoid cursors?

Answer Posted / veeresh kethari

1.By using case.. set,we can avoid the cursors

2.By using temporary tables/table variables/CTE
with while loop we can avoid cursor in the transaction.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the olap features?

957


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1009


What is page-level compression?

965


Does transparent data encryption provide encryption when transmitting data across the network?

1047


What is a non clustered primary key?

925


What is data set in report?

135


What is transaction server consistency?

1046


Explain different forms of normalization?

948


Why olap is used?

974


What is usually the first word in a sql query?

1136


What are binary string data types in ms sql server?

1296


What is Federation and Federation Member?

92


What are sub reports and how to create them?

139


What is parameterized reports in ssrs ?

149


What is field with example?

925