MSSQL 是否支持时间毫秒处理[毫秒精度]

运行环境:window server2003 数据库 SQLServer2008

例:
DECLARE @Date datetime
SET @Date=DATEADD(millisecond,-1,’2016-02-04 00:00:00.000′)
—-1毫秒
SELECT @Date as [1毫秒]
—-2毫秒
SET @Date=DATEADD(millisecond,-2,’2016-02-04 00:00:00.000′)
SELECT @Date as [2毫秒]
—-3毫秒
SET @Date=DATEADD(millisecond,-3,’2016-02-04 00:00:00.000′)
SELECT @Date as [3毫秒]
—-4毫秒
SET @Date=DATEADD(millisecond,-4,’2016-02-04 00:00:00.000′)
SELECT @Date as [4毫秒]
—-5毫秒
SET @Date=DATEADD(millisecond,-5,’2016-02-04 00:00:00.000′)
SELECT @Date as [5毫秒]
—-6毫秒
SET @Date=DATEADD(millisecond,-6,’2016-02-04 00:00:00.000′)
SELECT @Date as [6毫秒]
—-7毫秒
SET @Date=DATEADD(millisecond,-7,’2016-02-04 00:00:00.000′)
SELECT @Date as [7毫秒]
—-8毫秒
SET @Date=DATEADD(millisecond,-8,’2016-02-04 00:00:00.000′)
SELECT @Date as [8毫秒]
—-9毫秒
SET @Date=DATEADD(millisecond,-9,’2016-02-04 00:00:00.000′)
SELECT @Date as [9毫秒]

运行效果:
MSSQL毫秒精度计算

总结:
MSSQL毫秒级,目前只支持 1/4 毫秒