What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / vijay
There is No Difference between these two
| Is This Answer Correct ? | 35 Yes | 3 No |
Post New Answer View All Answers
What are the types of user defined functions in sql server?
How to backup encryption key ?
Are null values the same as that of zero or a blank space?
What is the index requirement in SQL Azure?
Mention the differences between substr and charindex in sql server.
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the largest component inside a field?
What is a self join in sql server?
What is a fill factor?
In which format does an image save in SQL Server database ?
What are cursors and when they are useful?
What is unique key constraint?
Differentiate between SQL and ORACLE joins and write their syntax.
What is merge?
What are the differences between user defined functions and stored procedures?