The results of both queries will be same but 2nd will fast then 1st vid

What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table

Question Posted / vidit

Answer Posted / vidit

The results of both queries will be same
but 2nd will fast then 1st

vidit Tyagi
Meerut

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a fill factor?

1140

What is the most common trace flags used with sql server?

1117

What is the difference between value type and reference type?

988

Can we write trigger for view?

1069

What do you mean by sql server 2005 express management tools?

1353

What are the 7 disadvantages to a manual system?

1030

What is sql collation?

1269

What are the types of sql server?

1096

How can we determine what objects a user-defined function depends upon?

1069

Why functions are used in sql server?

1016

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1134

How do you delete duplicate records in sql server?

1126

How can I add Reporting Services reports to my application?

132

What are the differences between lost updates and uncommitted dependencies?

1141

Tell me about normalization in DBMS.

1061