What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / naren
No difference
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to Insert multiple rows with a single insert statement?
how to define testing of network layers? : Sql server database administration
Explain the microsoft sql server delete command? : SQL Server Architecture
Explain forward - only cursors?
Explain optimistic and pessimistic concurrency?
What are the types of processing and explain each? : sql server analysis services, ssas
What are subqueries in sql server?
How to use “drop” keyword in sql server and give an example?
What is report snapshot?
What is the difference between commit and rollback?
How to enable tcp/ip protocol on a sql server?
What are the 7 disadvantages to a manual system?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Why use stored procedures in sql server?
How to select true false based on column value in sql server?