IN Vs OR operator which is best to use sql server.
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to apply filtering criteria at group level with the having clause in ms sql server?
How sql server executes a statement with nested subqueries?
Create and insert into temp table in sql server?
Do you have any idea about the tcl commands?
Explain trigger classes i.e. Instead of and after trigger?
What is the difference between index seek vs. Index scan?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to convert numeric expression data types by assignment operations?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is an example of a foreign key?
Explain the steps to create and execute a user-defined function in the sql server?
Explain about system stored procedure?
What Is Rdbms?
What is merge join?
How each E-R model constructs can be mapped to the relational model?