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
What are the differences between local and global temporary tables?
What is the difference between count and distinct count?
what is hash nonclustered index
How do triggers work?
Which are new data types introduced in sql server 2008?
How to Update from select query in sql server?
Define Business Edition in SQL Azure?
Difference between LEN() and DATALENGTH() in sql server ?
What is database black box testing?
Explain user defined views?
Which autogrowth database setting is good?
what's the information that can be stored inside a bit column? : Sql server database administration
How does using a separate hard drive for several database objects improves performance right away?
What is left outer join in sql server joins?
How do you send email on SQL Server?