Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49772 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / pavan
hey! I too agree there wont be any difference in result it
displays but the performance will be different. While
executing the first query the where condition to be checked
for each record it displays hence it takes much time to
execute while compared with question no 2 i.e, without
where condition. this is what I believe in.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is report snapshot in ssrs?
Explain the collation?
What is the difference between locking and multi-versioning?
What is self contained sub query?
What is simple indexing method?
What command would you use to add a column to a table in sql server?
How to install sql server 2005 express edition?
Do you know the cursor types?
How to recreate an existing index in ms sql server?
Describe how to use linked server?
What are the properties of primary key?
What are trace files?
Tell me what is fill factor?
What happens if ntwdblib.dll is missing on your machine?
Name and describe few console utilities for ssrs?
