IN Vs OR operator which is best to use sql server.
Answer Posted / 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')
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to invoke a trigger on demand?
What are the different types of lock modes in sql server 2000?
How many triggers are possible per table?
How will you make an attribute not process? : sql server analysis services, ssas
Explain stored procedure?
What is DCL?
What is a data source file?
What is store procedure? How do they work? When do you use?
What is read committed?
What is an expensive query?
how to trace the traffic hitting a sql server? : Sql server database administration
What are commonly used mssql functions in php?
What are the different types of data sources in ssrs?
What are different types of views?
How to create a view with data from multiple tables?