What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45294 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / malathi
Both the Queries will return the same ouput.
That means it will return all the rows that are available
in the table.
| Is This Answer Correct ? | 45 Yes | 3 No |
Post New Answer View All Answers
how to determine the service pack currently installed on sql server? : Sql server database administration
How to delete existing triggers using "drop trigger"?
What is normalization and what are the advantages of it?
What type of locking occurs during the snapshot generation? : sql server replication
What is normalization process?
What is the datatype of rowid?
Define indexes?
How to convert numeric expression data types using the cast() function?
Explain candidate key, alternate key, and composite key?
in the physical file layout, where should the transaction log be stored in relation to the data file?
how many type of indexing in database?
How do users use Report Builder with SQL Server data sources?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Which language is supported by sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
