NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME OUTPUT....

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

Question Posted / rohit nanda

Answer Posted / rohit nanda

NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain indexing and what are the advantages of it?

1070

What are the types of indexes?

1132

Is BCNF better than 2NF & 3NF? Why?

1104

What is reportserver and reportservertempdb ?

160

What is standby servers? Explain types of standby servers.

1053

What is the syntax for encrypting a column in SQL Server?

1174

Give the query of getting last two records from the table in SQL SERVER?

1008

What is mean by candidate key?

1061

How to trouble shoot if unable to connect SQL Server

2031

What happens if you delete a table that is used by a view?

1061

How do I create a trace in sql server?

1090

Difference between report and query parameter.

1144

Explain subquery and state its properties?

1090

What is set nocount on?

994

Which is the latest version of sql server and when it is released?

1197