Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49426 Views
- HP, I also Faced
- E-Mail Answers
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 subquery explain with example?
How do I view a procedure in sql server?
How to integrate the ssrs reports in application?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Define cross join in sql server joins?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How can we call UDF(User Define Function) using C# code in ASP.net ?
can a database be shrunk with users active? : Sql server administration
How to write an inner join with the where clause in ms sql server?
Do you know what is rank function?
What are the common performance issues in sql server?
How to use “drop” keyword in sql server and give an example?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is a rollup clause?
