What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 47255 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / g.nageswara rao
in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two
| Is This Answer Correct ? | 39 Yes | 3 No |
Post New Answer View All Answers
What is the new security features added in sql server 2014? : sql server security
Why do we use trigger?
What is a with(nolock)?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
When I run the sql server 2000 setup, it just hangs. What do I do?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
SQL Server Architecture ?
What authentication modes does sql server support?
How to send email from database?
How do I find query history in sql server?
Can a unique index be created on a column, which contains null?
What is SQL Azure Data sync?
What is the difference between an index and a unique index?
What is sql azure database?
What encryption security is available in sql azure?
