Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43613 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / debasish
we can use having clause without group bu clause .but it
will act as where clause
| Is This Answer Correct ? | 68 Yes | 33 No |
Post New Answer View All Answers
What are the hotfixes and patches in sql server?
Explain about integration services of Microsoft SQL server?
What is indexed view? How to create it?
What are the 2 types of classifications of constraints in the sql server?
What does <> symbol mean?
What is the meaning of sql server?
How to find the source of a table in sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is user-defined functions? What are the types of user-defined functions that can be created?
How to view existing indexes on an given table using sys.indexes?
What is the difference between push and pull subscription? : sql server replication
What is query and its types?
Explain about system database?
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
What is the difference between index seek vs. Index scan?
