What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
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
What is the difference between a view and a stored procedure?
What are the different methods available under sqlcommand class to access the data?
Does partitioning ssd reduce performance?
What are the drawbacks of reporting in ssrs?
What is the use of sign function?
What is Federation Root Database?
Explain logical operators in sql server?
Who developed sql server?
What is difference between rollback immediate and with no_wait during alter database?
Explain what is analysis service repository?
What is the purpose of the tempdb database?
How to create a simple user defined function in ms sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What the different types of Replication and why are they used?
Explain about builtinadministrator?