What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / niranjan prasad
There is no defference in result. It shows same result-set
by using both the command.This question put you to misguide
only.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a fill factor of 100 and 0?
What new data source types were added in ssrs 2014?
How can sql injection be stopped? : sql server security
What is use of except clause? How does it differ from not in clause?
what information is maintained within the msdb database? : Sql server administration
What is difference between standardization and normalization?
Explain about protocol layer present in SQL server?
Is t sql the same as sql server?
How to drop an existing user defined function in ms sql server?
What stored by the model? : sql server database administration
Do you know the cursor types?
What are the source of constraints?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is the difference between commit and rollback?
What is for xml in sql server?