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
- 49797 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
What are the indexes in sql server?
What are clustered and non-clustered index?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is the difference between count () and rowcount ()?
Explain the difference between HTTP and HTTPS in database?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to use "begin ... End" statement structures in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
How do I view a stored procedure in sql server query?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the order by used for?
Do you know exporting and importing utility?
Why do we need different type of parameter?
What are the restraints imposed on the table design by a merge replication?
