There is No Difference between these two

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

Question Posted / vijay

Answer Posted / vijay

Is This Answer Correct ?

35 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is data block and how to define data block size?

596

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

546

How to drop an existing schema in ms sql server?

591

How can we use ConnectorJ JDBC Driver with MS SQL?

564

Why would you use sql agent?

727

What are the types of normalization?

547

How do you migrate data from mssql server to azure?

151

What is mean by candidate key?

538

Define Wed Edition in SQL Azure?

What is the purpose of update statistics and scope_identity() function?

597

Can you explain what is indexed view? How to create it?

522

Is it possible to replicate data from sql server to oracle? : sql server replication

540

Explain filtered indexes?

551

What is 1nf normalization form?

587

What are different types of database indexes?

524