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
- 49378 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / vidit
The results of both queries will be same
but 2nd will fast then 1st
vidit Tyagi
Meerut
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to provide values to user defined function parameters?
What happens if ntwdblib.dll is missing on your machine?
What is optimistic concurrency?
How to declare a cursor with "declare ... Cursor" in ms sql server?
How to return the date part only from a sql server datetime datatype?
Do you know what are different types of replication in sql server?
How to modify an existing stored procedure in ms sql server?
Explain triggers in sql?
What is difference between oltp and olap?
Explain can you implement data mining in ssrs?
How do you drop an index?
What are the different types of columns types constraints in the sql server?
What are different types of raid levels?
What do you understand by recursive stored procedures?
Why truncate is ddl?
