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
- 49816 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / rohit nanda
NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to create an index on an existing table in ms sql server?
How to find out what is the default collation in a database?
Explain acid?
How do I edit a stored procedure in sql server?
What is standby servers? Explain types of standby servers.
What are the types of indexes?
Define right outer join in sql server joins?
How can I get data from a database on another server?
What are the properties of the relational tables?
Determine when an index is appropriate?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Where do we use trace frag?
What new changes are being made in SQL Server?
How to replace the Query Result 'Null Value' with a text ?
What is a covering index?
