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

Which is the best place or learning center for MS SQL?????In Bangladesh?????

0 Answers   TCL, Wipro,

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

What command is used to rename the database?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

How to loop through returning rows?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

How to truncate a table first before running a package?

1 Answers  

---

What is a view in sql?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

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

3 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---