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   To Refer this Site to Your Friends   Click Here
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 
IN Vs OR operator which is best to use sql server.
 Question Submitted By :: Preethi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: IN Vs OR operator which is best to use sql server.
Answer
# 1		 
hi i am swaraj.
Ans:-

As per my opinion The IN operator is best B'coz
Due to IN operator at one time multipale requirtment
van satisfied
But Due to OR operator Only one requirtment get satisfied.
So IN operator is Good.
 
Is This Answer Correct ?    0 Yes 0 No
Swaraj
 
  Re: IN Vs OR operator which is best to use sql server.
Answer
# 2		 
hi i am swaraj.
Ans:-

As per my opinion The IN operator is best B'coz
Due to IN operator at one time multipale requirtment
van satisfied
But Due to OR operator Only one requirtment get satisfied.
So IN operator is Good.
 
Is This Answer Correct ?    0 Yes 0 No
Swaraj
 
 
 
  Re: IN Vs OR operator which is best to use sql server.
Answer
# 3		 
in is peferable bcoz
by using in we can write set of values at time n check it 
where as when we use or we need to mention for each n every 
value
like ...
select emp_id from employee where emp_id in(1,2,3,4..)
but in case of or...
select emp_id from employee where emp_id=1 or emp_id=2 or 
emp_id=3 or emp_id=4...
 
Is This Answer Correct ?    1 Yes 0 No
Harinireddy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000? Infosys1
What are the differences between stored procedure and functions in SQL Server 2000? TCS7
can any one please send sql quries most used in applications.  1
what is hash table Teledata2
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
What is referential integrity? What are the advantages of it? Digital-Domain2
What is the system function to get the current user's user id? HCL1
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table. Techno-Solutions2
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  1
how to get the automatic backup of the database in the sql server  3
explain different types of jions with examples briefly? Zensar1
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
What is the datatype returned by count(*) Asian-CERC16
Can you give an example of Stored Procedure?  2
how to rename the table  1
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS4
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies9
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan? HCL2
Which institute is best for SQL Server 2005 Training?  4
What is the difference between constraints and triggers? Wipro5
 
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