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
- 50377 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
How do I find the default sql server instance?
What are ddl (data definition language) statements for tables in ms sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What to check if a User database is locked?
What are the system database in sql server 2005?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Explain use of expression builder.
Explain sql server service broker?
What is the xml datatype?
Do you think BCNF is better than 2NF & 3NF? Why?
What is rolap and its advantage? : sql server analysis services, ssas
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to stop log file growing too big?
Can you import Microsoft Excel data to SSRS?
List out the differences between the clustered index and non-clustered index in sql server?
