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
what are the different stages of Report Processing?
What is the ‘fillfactor’?
Explain what are page splits? : SQL Server Architecture
How to create percentile function?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is SQL Server?
What is a user-defined function in the sql server and what is its advantage?
What is the difference between deallocate cursor and close cursor?
How do you troubleshoot errors in a SQL Server Agent Job?
Can you explain what is indexed view? How to create it?
How to convert a unicode strings to non-unicode strings?
Explain what are partitioned views and distributed partitioned views?
What will be the maximum number of index per table?
Explain temporary table vs table variable by using cursor alternative?
How to call stored procedure using http soap?