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
- 49168 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / akbar ali
The first query satisfies the condition true condition.
both are similar but not same. performance based querys ...
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is a partitioned view?
What do you mean by subquery?
What are cursors stored procedures and triggers?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Do you know what is xpath?
What are user-defined functions (udfs) in sql server?
How to drop an existing table with "drop table" statements in ms sql server?
what is a correlated sub-query? : Sql server database administration
What is the use of commit?
What are the different types of triggers in SQL SERVER?
Which sql server is best?
What is a DBMS, query, SQL?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Why do we partition data?
