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
- 50372 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 the difference between functions and stored procedures?
Define right outer join in sql server joins?
Can we insert data into view sql server?
What is a trigger and its types?
What is explicit cursors?
what is the difference between Tabular and Matrix report?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Do you know data definition language, data control language and data manipulation language?
Why use triggers?
What is the difference between a primary key and a unique key? Are they the same?
How to concatenate two strings in SQL Server.
What does this statement do @@rowcount?
How to modify an existing user defined function?
What command do we use to rename a db, a table and a column?
