What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
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
What is save transaction and save point?
What is the difference between resultset and resultsetmetadata?
What is the fillfactor concept in indexes?
what is a correlated sub-query? : Sql server database administration
What is Federation and Federation Member?
What are subqueries in sql server?
Explain what are the restrictions while creating batches in sql server?
What is single-user mode?
What is "scheduled jobs" or "scheduled tasks"?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to delete existing rows in a table?
What is a covered index?
What is tabulation?
What does it mean to be in union?
Explain what role entity and relationship play in an ER diagram.