What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45367 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / krishna sandeep
Of course, both the Queries will get you the same data but,
When compared to the first case processing time will be
slightly reduced in the second case.
Bytes sent from client and Bytes received from server will
be more in the first case.
and one more thing is better not using "select * from ..."
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Explain partitioned view?
How can I track the changes or identify the latest insert-update-delete from a table?
What are logical/boolean operations in ms sql server?
How do I uninstall sql server 2014?
when would you go for denormalization? : Sql server database administration
Explain the benefits of user-defined functions?
How do you handle datasets larger than 50 gb?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are data resources?
What is the use of floor function in sql server?
What is difference between inner join and full join?
what are database files and filegroups? : Sql server database administration
What types of replication are supported in sql server?
How to rename databases in ms sql server?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
