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
- 49958 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
Can you name some of the dml commands in sql?
What are scheduled tasks in sql server?
What are the two modes of authentication in sql server?
What is lock escalation? : sql server database administration
Explain the benefits of user-defined functions?
What are differences in between sql server 2012 and sql server 2016?
How can sql server instances be hidden? : sql server security
What is the difference between createstatement and preparedstatement?
What is order of B+tree?
How to find table changes in sql server?
Explain cdc and sql injection?
Explain the use of containers in ssis?
Explain the dbcc pintable command when would you use it?
What are recommended options to be used while using db mirroring? : sql server database administration
what are the core components of SSRS?
