No difference

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

Question Posted / naren

Answer Posted / naren

No difference

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the differences between local and global temporary tables?

1129

What is the difference between count and distinct count?

929

what is hash nonclustered index

1022

How do triggers work?

994

Which are new data types introduced in sql server 2008?

1104

How to Update from select query in sql server?

1116

Define Business Edition in SQL Azure?

102

Difference between LEN() and DATALENGTH() in sql server ?

1170

What is database black box testing?

1072

Explain user defined views?

1008

Which autogrowth database setting is good?

1096

what's the information that can be stored inside a bit column? : Sql server database administration

1086

How does using a separate hard drive for several database objects improves performance right away?

988

What is left outer join in sql server joins?

1106

How do you send email on SQL Server?

1116