ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
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 Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1		 
Use Table variable with a identity column. Then make a while
loop row by row
 
Is This Answer Correct ?    2 Yes 0 No
Anupom Das
 
  Re: 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
# 2		 
Use Table variable with a identity column. Then make a while
loop row by row
 
Is This Answer Correct ?    1 Yes 0 No
Anupom Das
 
 
 
  Re: 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
# 3		 
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
Prasanna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT CTS10
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000? Infosys1
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
How to write query to Delete the records in child table and corresponding records in parent table Semantic-Space8
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?  6
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup3
What are the main control-of-flow T-SQL constructs?  1
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
What are the steps you will take to improve performance of a poor performing query? HCL1
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005  2
what is web server? Satyam3
WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh2
What is the difference between truncate and delete statement? CTS4
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam4
one table has four field id,name,design,salary. i have to find maximum salary .  6
What is database normalization? Digicel5
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,... ADP5
What is MSDE?  2
how to delete duplicate rows from table in sql server HCL8
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com