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

How to encrypt Strored Procedure in SQL SERVER?

1167

How will you hide an attribute? : sql server analysis services, ssas

958

How to update a field in SQL after ALTERING a row?

1232

Explain syntax for viewing trigger?

926

Mention a few common trace flags used with sql server?

930

How can you stop stored procedures from recompiling?

900

How to create a view using data from another view?

948

What are the restrictions that views have to follow? : SQL Server Architecture

1001

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

987

How you can add messages to the nt event log from within a stored procedure?

1069

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

What it means to be triggered?

1008

How do I delete a sql server database?

1043

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

946

Is it possible to update the views? If yes, how, if not, why?

1029