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 ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How to select some specific columns from a table in a query in ms sql server?
Can we use where and having clause together?
How can you insert null values in a column while inserting the data?
What is resultset concur_updatable?
How to create indexed view?
How to concatenate two binary strings together?
What is save transaction and save point?
What are the properties of primary key?
Do you know the capabilities of cursors?
Explain about extended stored procedure?
What is repeatable read?
What are the recovery models in sql server 2000?
What is a View ? Can we insert, Update and delete a view?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.