What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
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
Can we add our custom code in ssis?
What are the new data types are introduced in sql 2000?
What is bcp? When does it used?
How do I open port 1433?
What is the correct order of the logical query processing phases?
What is sql view?
how can you attach more than 20 ldf files in sql server
What are the new features are introduced in sql server 2012 reporting services?
what are the different types of SSRS reports?
What is lock escalation? : sql server database administration
Can primary key be a foreign key?
What is sparse columns of sql server 2008?
Which data type columns are the best candidates for full-text indexing?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is inner join? Explain with an example?