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

Can you give an example of Stored Procedure?

4 Answers   Wipro,

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

What is the difference between a view and a stored procedure?

0 Answers  

Explain different types of lock modes in sql server 2000?

0 Answers  

Define magic tables in sql server?

0 Answers  

Explain the types of indexes.

0 Answers   Accenture,

When do you think a developer should use sql server-based cursors?

0 Answers  

Explain primary key?

0 Answers  

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

What are the advantages of having an index on the sql server?

0 Answers  

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

Tell me what is log shipping?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories