What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45298 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / g.nageswara rao
in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two
| Is This Answer Correct ? | 39 Yes | 3 No |
Post New Answer View All Answers
How to convert a unicode strings to non-unicode strings?
How sql server enhances scalability of the database system?
Explain the difference between control flow and data flow?
How to create an index on an existing table in ms sql server?
What is the exact numeric data type in sql?
Tell me about joins in database system and explain each in detail.
Is it important for a database administrator to understand the operating system and file access?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Why do we backup Active Directory ?
What are different types of replication in sql server?
Explain the different index configurations a table can have?
explain the storage models of olap? : Sql server database administration
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is acid mean in sql server?
Describe and explain about SQL native client?
