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

In which year relase the 7.0& 2000 & 2005?

1 Answers  

Explain the types of indexes.

0 Answers   Accenture,

How is foreign key related to primary key?

0 Answers  

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

What is an index. What are the types?

0 Answers  

Comment,Datatypes are unlimited

0 Answers   IBM,

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

can an order by clause be used in a creation of a view?

0 Answers  

Can we join two tables without primary key?

0 Answers  

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

What is the language structure to add a record to a table?

0 Answers  

Why variables called the most powerful component of ssis?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories