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
- 49936 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / hitesh taneja
When we use 1=1 or any condition which is always going to
true, it will take extra bit of time bcoz it is a condion so
althouth the output of the query will be the same the
performance time will be bit higher with condition.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to recover from sql injection? : sql server security
What is cached report?
What's the information that can be stored inside a bit column?
How to create a stored procedure with a statement block in ms sql server?
What is ms sql server index?
Explain cdc and sql injection?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is sql profiler. What are the default templates with it? : sql server database administration
What are the types of containers in ssis?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain the use of containers in ssis?
What are pessimistic lock and optimistic lock?
What are a scheduled jobs?
Why it is recommended to avoid referencing a floating point column in the where clause?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
