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 my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

What are the 7 disadvantages to a manual system?

0 Answers  

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

Explain syntax for viewing trigger?

0 Answers  

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

What is a with(nolock)?

0 Answers  

Explain about analysis services?

0 Answers  

how you can list all the tables in a database?

0 Answers  

How do you optimize Sql queries ?

0 Answers   Cognizant,

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

For more SQL Server Interview Questions Click Here
Categories