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
- 49858 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / kranthi kiran
I am learning SQL Basics..So If my Answer is wrong Plz do
reply to tht,
In the First Query Where 1=1 implies Show all where The
first coloum element is equal to 1
and second query show all from table
| Is This Answer Correct ? | 4 Yes | 40 No |
Post New Answer View All Answers
Can you explain full-text query in sql server?
Define outer join in sql server joins?
Please explain what is “asynchronous” communication in sql server service broker?
what are user defined datatypes and when you should go for them? : Sql server database administration
What happens when the SQL Azure database reaches Max Size?
What is an execution plan? How would you view the execution plan?
What is acid db?
What is bcnf normalization form?
how would you improve etl (extract, transform, load) throughput?
What are the restrictions that views have to follow?
What is user-defined inline table-valued function?
What is blocking and how would you troubleshoot it? : sql server database administration
Do you know sql server 2008 introduces automatic auditing?
Can we delete data from a view?
What is a mutating table error and how can you get around it?
