A small problem with datetime accuracy

In general, when judging the time, the use of a datetime type is sufficient. But there are situations, such as the following

DECLARE @DT1 DATETIMEDECLARE @DT2 DATETIME SELECT @DT1 = '2014-12-22 15:45:00:128',  @DT2 = '2014-12-22 15:45:00:126' IF @DT1 > @DT2     SELECT GETDATE()

Find out the result is empty ~ eh??

And then we find that it's a matter of accuracy. Check it out. Document discovery is indeed, then (thanks to the Almighty online documentation)

If this is the case, you can change the datetime to DateTime2. Higher accuracy

A small problem with datetime accuracy