Interested to Buy Any Domain ? << Click Here >> for more details...
IN Vs OR operator which is best to use sql server.
- 4 Answers
- 11738 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
What are trace flags and mention a few common trace flags used with sql server?
What are SSL and TSL protocols?
When a primary key constraint is included in a table, what other constraints does this imply?
What is clr ddl trigger?
How does index makes search faster?
How to drop existing views from a database in ms sql server?
Why do you need a sql server?
What is report snapshot in ssrs?
When does a workload on SQL Azure get throttled?
How to trouble shoot if unable to connect SQL Server
What happens to a trigger with multiple affected rows?
How do you delete duplicate records in sql server?
Does the unique constraint create an index?
What is a cache in ssrs?
What are statistics?
