What is the difference between WHERE AND IN?
OR
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?
Answer Posted / mohan
both are same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain how many normalization forms?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Write the SQL query to drop, truncate and delete table.
What are subqueries in sql server? Explain its properties.
How can you start sql server in different modes?
What is extent? Types of extents?
What is row_number()?
What is an example of a primary key?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are functions in the sql server?
Which database stores information about replication?
How can sql server instances be hidden? : sql server security
What are the features of Embedded SQL