What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / rohit nanda
NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
what is the difference between Tabular and Matrix report?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the new features of sql server 2012 reporting service?
Describe in brief sql server monitoring ways.
What is the purpose of floor function?
How we can refresh the view?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
what is a schema in sql server 2005? : Sql server database administration
What methods do you follow to protect from sql injection attack?
Write an sql query to find first weekday of the month?
What is raid and what are different types of raid levels?
What is the difference between a local and a global temporary table?
What are the types of sql server?