sql server - add a constraint on a datetime column -

I want to add an obstacle to an id column and a date-time column, so that an ID can be entered only once the following datetime 2015-03-17 12:48: 00 , it will not rejoin at the same date time, but if the time is changed to 2015-03-17 12:45:00 to ID gets re-entered

connect to the bar of the date portion of the Date column Is there a way to do it?

I do not think you can, but you have different options:

< Ul>

Change your column to the only part of the date

Create a calculation column where you edit

according to the comment: @ a- ツOther options are:

• Split