What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / vijay
There is No Difference between these two
| Is This Answer Correct ? | 35 Yes | 3 No |
Post New Answer View All Answers
What is server-level principal?
Explain the phases a transaction has to undergo?
What are the system database in sql server 2008?
Define cross join in sql server joins?
What is the need for group functions in sql?
What stored by the msdb?
what are isolation levels? : Sql server database administration
What are the built in functions in sql server?
What are the tool windows in sql server management studio? : sql server management studio
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is a non clustered primary key?
Can you explain what is sql server english query?
What new data source types were added in ssrs 2014?
What is the maximum size of sql server database?
What are Spatial data types in SQL Server 2008