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
- 49933 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / hasan
Both are same .
They r showing all results.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Do you know what is sql injection?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is a transactions?
What happens if null values are involved in arithmetic operations?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is difference between join and natural join?
What are the advantages of log shipping?
Explain candidate key, alternate key, and composite key?
What does select 1 mean?
Explain transaction server distributed transaction?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the sql server agent?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is instead of dml trigger?
Does sql server use java?
