IN Vs OR operator which is best to use sql server.
- 4 Answers
- 10858 Views
- I also Faced
- E-Mail Answers
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 determine the service pack currently installed on sql server? : Sql server database administration
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How do I uninstall sql server 2014?
Can I save my report as html, excel or word? : sql server management studio
What is the optimization being performed in oracle and SQL Server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is a rownum?
How many databases instances are there in sql server 2000?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the default port for SQL Server over a firewall?
How to update a field in SQL after ALTERING a row?
How do use Having,Group by,Group function in SQL?
What do you mean by sql server 2005 express management tools?
Difference between group by clause and having clause in SQL?
When we should use and scope of @@identity?
