What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45462 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / naren
No difference
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between delete,drop and truncate in SQL Server?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is the use of commit?
What is trigger and different types of Triggers?
Explain Geometry datatype in sql server 2008 with example
is it important for a database administrator to understand the operating system and file access? : Sql server administration
what is blocking? : Sql server database administration
Tell me what do you understand by a view? What does the with check option clause for a view do?
Does order by actually change the order of the data in the tables or does it just change the output?
How do I run sql server 2014?
How many servers can we create in a single subscription?
What is inner join in sql server joins?
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 table level trigger?
How to install sql server 2005 express edition?
