in first query 1=1 always true,then it retrives all columns in a table.

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

Question Posted / g.nageswara rao

Answer Posted / g.nageswara rao

in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two

Is This Answer Correct ?

39 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the recovery models in sql server 2000?

925

When we should use @@error?

904

What is a print index?

840

Can a rule be bound to any column of any data type?

909

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

891

Can you explain what are various ways to enhance the ssrs report?

954

How to create user defined functions with parameters?

1162

Difference between Logical Page and Physical Page in SSRS.

459

what is a transaction? : Sql server database administration

933

How to rename an existing column with sql server management studio?

948

What is Replication?

989

Where cross join is used?

902

What is meant by dirty read?

948

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

948

What are the disadvantages of merge replication?

1304