What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45364 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 is a field name?
Tell me what is the stuff and how does it differ from the replace function?
What is default port number for sql server 2000?
What are database states in ms sql server?
Which are the olap features?
What is default constraint?
What is sql server used for?
State the difference between local and global temporary tables?
What is difference between aggregate and analytic function?
Why normalization is used?
How to view existing indexes on an given table using sys.indexes?
Explain syntax for dropping triggers?
What is role playing dimension with two examples? : sql server analysis services, ssas
Which language is supported by sql server?
How can we delete Duplicate row in table?
