No Diffrence at all

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

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

No Diffrence at all

Is This Answer Correct ?

57 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is raiseerror? What is raiseerror?

1192

Explain an automatic checkpoint

1011

How to delete an existing database user?

1076

Explain active/passive and active/active cluster configurations?

1103

What will be the maximum number of indexes per table?

1015

Explain various On-Delete options in a DB table. Which is the default option?

1528

What happens when converting big values to numeric data types?

1222

What is sql server database?

1077

What do you understand by the data quality services in sql server?

979

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

1079

What is an indexing strategy?

1063

What is GUID in sql server?

1221

Can foreign key be duplicate?

1116

last function used in MS Access to convert sql what function will use in sql

2114

How to execute the cursor queries with "open" statements?

1237