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

How to delete an existing database user?

1010

State the difference between local and global temporary tables?

1105

How do users use Report Builder with SQL Server data sources?

152

What is standby servers? Explain types of standby servers.

987

What are the different methods available under sqlcommand class to access the data?

1109

What is the use of tempdb? What values does it hold?

1059

what is package and it uses and how can u call a package

2010

How to download and install microsoft sql server management studio express?

1029

How do I schedule a sql server profiler trace?

968

Define master database?

1051

What is 1nf normalization form?

1024

How can windows applications connect to sql servers via odbc?

1116

Explain sql delete command?

1035

How do I view a script in sql server?

1029

Define model database?

964