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


Please Help Members By Posting Answers For Below Questions

What is the difference between a fill factor of 100 and 0?

762


What new data source types were added in ssrs 2014?

130


How can sql injection be stopped? : sql server security

747


What is use of except clause? How does it differ from not in clause?

766


what information is maintained within the msdb database? : Sql server administration

733


What is difference between standardization and normalization?

775


Explain about protocol layer present in SQL server?

824


Is t sql the same as sql server?

771


How to drop an existing user defined function in ms sql server?

819


What stored by the model? : sql server database administration

737


Do you know the cursor types?

893


What are the source of constraints?

706


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

697


What is the difference between commit and rollback?

713


What is for xml in sql server?

719