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')

What are the 7 disadvantages to a manual system?

0 Answers  

---

What is xdr?

0 Answers  

---

What are the advantages of using stored procedures in sql server?

0 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

Define the term DML, DDL and DTL?

1 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

How do I delete a sql server database?

0 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---