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
Explain in brief how sql server enhances scalability of the database system?
How to disable triggers using "disable trigger"?
What is merge replication?
Which are new data types introduced in sql server 2008?
How many types of database relationship in sql server?
What is 'Join' and explain its various types.
What is the purpose of grouping data in a report?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is indexing explain it with an example?
What is the difference between cartesian product and cross join?
What is the use of floor function in sql server?
What is raid, and how it can influence database performance?
Define full outer join in sql server joins?
what does the automatic recovery do? : Sql server administration
How to list all field names in the result set using mssql_field_name()?