No difference

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

Question Posted / naren

Answer Posted / naren

No difference

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain activity monitors

1076

Find first and last day of current month in sql server

1028

How to retrieve error messages using mssql_get_last_message()?

1054

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

977

What is temporal table?

887

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973

can an order by clause be used in a creation of a view?

1183

How to scale out a federation by Sql statement?

116

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1171

How can you check the version of sql server?

1095

What do you understand by user-defined function in the sql server?

951

Give a example to search fr a string in all stored procedure in sql server.

986

Explain syntax for viewing, dropping and disabling triggers?

953

What language is sql server written in?

1033

What is mscorsvw.exe - process - microsoft .net framework ngen?

955