What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 47340 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
Why do you want to join software field as you have done your BE in Electronics?
How to delete duplicate rows from table except one?
What is data modeling and Reterminal integrity?
Tell me something about security and sql azure?
What is transactional replication?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is side by side migration in sql server?
What is sql server query analyzer?
Is a primary key unique?
How to create database with physical files specified in ms sql server?
what is a check constraint?
Mention the 3 ways to get a count of the number of records in a table.
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is database dimension? : sql server analysis services, ssas
How to create new table with "create table" statements?
