What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / naren
No difference
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the need for indexing?
what is raid? : Sql server database administration
What is after dml trigger?
How exceptions can be handled in sql server programming?
How will you decide the active and passive nodes?
What is an identity?
What do you understand by integration services in sql server?
Explain the concepts and capabilities of sql server?
How is table type constraint applied to a table?
Explain different types of self contained sub query?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
If a stored procedure is taking a table data type, how it looks?
What is difference between standardization and normalization?
What is scheduled job and how to create it?
What types of replication are supported in sql server?