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
- 49169 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
Tell me what are the advantages of using stored procedures?
What is coalesce and check constraint in sql server?
What are number line correlation administrators will use while working with a subquery?
Mention the differences between sql server and mysql.
How to manipulate data from one table to another table ?
Can foreign key be deleted?
Where can you find the error log information? : sql server database administration
What is the user of Primary key?
How you can get a list of all the table constraints in a database?
How can we migrate from SQL server to SQL Azure?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How to configure and test odbc dsn settings?
What is difference between getdate and sysdatetime in sql server 2008?
What are “lost updates”?
What is the maximum size of sql server database?
