Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49859 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / vijay
There is No Difference between these two
| Is This Answer Correct ? | 35 Yes | 3 No |
Post New Answer View All Answers
How to make remote connection in database?
How many null values we can have in a unique key field in sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is SQL Azure Firewall?
Define Wed Edition in SQL Azure?
What is sql server programming?
Define Business Edition in SQL Azure?
What is difference between rownum and row_number?
What is single-user mode?
Define Unique Key?
What is bit data type?
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?
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
Is truncate a dml command?
Can you explain what are various ways to enhance the ssrs report?
