Sql-server-2008 Questions

Ad
Ad

Removing Duplicates With Exception

In the image below, you will notice that there are multiple instances where detailid is the same, however the ees_base_commission is 0 or 0.2.
Ad

Lock database for other application

I'm using sql server 2008 r2, someone is using my database via a macro code in excel, is there any way to prevent another application (like excel)
Ad
Ad

Convert the date format in sql?

How to take date without day.. example i get a date like '28-07-2015',and i need to convert it to like '00-07-2015'. when am inserting the date
Ad

Blog Categories

Ad