Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49898 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
What is triggers in ms sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What are partitioned views?
How to compare the top two records using sql?
How to create a new table in a given schema?
What are the steps to follow to configure SQL*Net?
How to choose all records from the table?
Explain what is the function of sql server agent windows service?
Explain the categories of stored procedure?
Can sql server be linked with other servers like oracle?
Can you explain the disadvantages/limitation of the cursor?
How to get the definition of a user defined function back?
How to connect php with different port numbers?
What is sparse columns of sql server 2008?
List out the different types of locks available in sql server?
