Answer / harinireddy

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...

Answer / swaraj

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.

Answer / swaraj

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.

Answer / sandeep rana

Both are used for different purposes like...

select * from table where data in(1,2,3,4,5,6)


select * from table where data in(1,2,3,4,5,6) or data1
like('%s','%t')

List out the difference between union and union all in sql server?

0 Answers  

---

How secure is sql server database?

0 Answers  

---

explain the storage models of olap? : Sql server database administration

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

How to get nth highest salary from employee table.

0 Answers  

---

What is a trigger?

4 Answers  

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

How do you trace the traffic hitting a sql server?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

What are xml indexes?

0 Answers  

---

How do I create a partition table in sql server?

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---