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
- 49200 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / hitesh taneja
When we use 1=1 or any condition which is always going to
true, it will take extra bit of time bcoz it is a condion so
althouth the output of the query will be the same the
performance time will be bit higher with condition.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are isolation levels? : Sql server database administration
What is conditional split?
what are the types of indexes? : Sql server database administration
What are the advantages of using stored procedures?
How will you go about resolving deadlocks?
Explain transaction server explicit transaction?
How to modify the underlying query of an existing view?
What are sql servers used for?
How to trouble shoot if unable to connect SQL Server
Explain left outer join and right outer join?
What is the default Port No on which SQL Server listens?
What is the report builder?
How does Report Builder support Analysis Services cubes?
What is difference between rollback immediate and with no_wait during alter database?
How to specify the collation for a character data type in ms sql server?
