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
- 49176 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
Is it safe to delete log files?
Which command is used for user defined error messages?
Explain nested join?
What is BCP? When does it used in sql server 2012?
What is command parameter in ssrs?
what protocol both networks use? : Sql server database administration
What is the definition for sql server 2000?
How to use clusters?
What is the difference RDBMS and Graph Database?
List the data types available in mssql?
What language is sql server written in?
How to retrieve error messages using mssql_get_last_message()?
What are sql servers used for?
Define a cross join?
What is default constraint in ms sql server?
