Interested to Buy Any Domain ? << Click Here >> for more details...
IN Vs OR operator which is best to use sql server.
- 4 Answers
- 11811 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 control the amount of free space in your index pages? : Sql server database administration
Define candidate key, alternate key, and composite key.
How to find the version of sql server? : sql server database administration
How do triggers work?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is difference statement and preparedstatement?
What is the correct order of the logical query processing phases?
What is the command dbcc checkdb used for?
Explain the properties of subqueries in sql server?
What are translations and its use? : sql server analysis services, ssas
How can I get data from a database on another server?
How can windows applications connect to sql servers via odbc?
What is 1nf 2nf and 3nf?
Why we need sql server?
What is the difference between nvl and nvl2?
