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
Why de-normalization required?
How to create an identity column?
What is log in sql server?
explain extended properties
What is the log shipping?
How to retrieve error messages using odbc_errormsg()?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the system database in sql server 2005?
What is filtered index?
How to create view in stored procedure sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How do I view a script in sql server?
What causes index fragmentation?
What are sub reports?