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
- 49404 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 indexing explain it with an example?
What is a collation?
what authentication modes does sql server support? : Sql server database administration
What is 'Join' and explain its various types.
what is the main function of a query parameter?
What are partitioned views?
Describe the left outer join & right outer join. : sql server database administration
What is nolock?
How connect excel to sql server?
Explain the collation?
What are the types of normalization?
What are the different types of subquery?
How many tables can be joined in SQL Server?
How do I schedule a sql server profiler trace?
What is the primary use of the model database?
