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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback



could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / 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

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / anupom das

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

Is This Answer Correct ?    1 Yes 0 No

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a sit..

Answer / prasanna

Use derived columns,corelated subqueries instead of cursors
so that the performance will also be improved.

Regards
prasanna

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain syntax for viewing trigger?

0 Answers  

Create and insert into temp table in sql server?

0 Answers  

Can foreign key be deleted?

0 Answers  

What is buffer cash in sql server?

0 Answers  

How to create Clustered Primary Key to table?

2 Answers  

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

How to update values in a table with update statements in ms sql server?

0 Answers  

What is sql server programming?

0 Answers  

What is Trigger?

3 Answers   Misys,

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

How to make remote connection in database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories