Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between HAVING clause and the WHERE
clause?
- 7 Answers
- 16122 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
As per my knowledge WHERE is for conditional retrieving but
we cann't use Average Functions in WHERE clause.
HAVING clause can include AVG Functions.
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
where the connection string store in the database
Explain view in sql server?
What is single-user mode?
What are the diifferences between the ms sql server vs mysql?
Which data type columns are the best candidates for full-text indexing?
what is nonclustered index
What are key constraints?
explain declarative management framework (dmf) in sql server 2008?
Explain for xml explicit mode?
Explain what is analysis service repository?
What is Lock table in SQL?
How does index makes search faster?
Explain important index characteristics?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
