What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 47256 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / akbar ali
The first query satisfies the condition true condition.
both are similar but not same. performance based querys ...
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are page splits?
How to write a query with an inner join in ms sql server?
Explain steps of normalization?
What is difference between global temporary tables and local temporary tables?
Does a sql server 2005 select statement require a from?
Explain the difference between cross join and full outer join?
Explain syntax for viewing trigger?
How to use "begin ... End" statement structures in ms sql server?
What do you understand by a stored procedure?
Does windows server 2016 come with sql server?
In which tcp/ip port does sql server run? Can it be changed?
Can we add an identity column to decimal datatype?
What is the use of toad or sqldbx.?
What is the Control Flow in SSIS
What is mapping schema?
