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

could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.

3.What is computed columns?

Thanks in advance.

Regards,
Rupesh

Answer Posted / anupom das

Use Table variable with a identity column. Then make a while
loop row by row

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the xml datatype?

993


Can you force a query to use a specific index?

889


How to name query output columns in ms sql server?

918


What is attribute hierarchy? : sql server analysis services, ssas

963


What does top operator do?

965


What are the built in functions in sql server?

919


Can two tables share a primary key?

952


What are the different editions available in sql server 2000?

995


What is tabulation?

899


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

982


How to create nested stored procedure?

950


What do you mean by data integrity?

998


Which database stores information about replication?

991


What is explicit cursors?

991


What is pessimistic concurrency?

924