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
- 49253 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
How to connect to a sql server using odbc_connect()?
Why use update_statistics command in sql server?
What do mean by xml datatype?
What are the different types of collation sensitivity?
What you can do to delete a table without the delete trigger firing?
What do you mean by recursive stored procedure?
What is set nocount on?
What is the use of sign function?
What are the benefits of normalization?
Does index speed up select statements?
State the difference between union and union all?
How do I start sql server 2017?
Working with TLogs
What do you understand by the analysis services in sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
