我有一個像這樣結構的表:CREATE TABLE [TESTTABLE]( [ID] [int] IDENTITY(1,1) NOT NULL, [DateField] [datetime] NULL, [StringField] [varchar](50), [IntField] [int] NULL, [BitField] [bit] NULL)我執行以下代碼:BEGIN INSERT INTO TESTTABLE (IntField, BitField, StringField, DateField) VALUES ('1', 1, 'hello', {ts '2009-04-03 15:41:27.378'}); SELECT SCOPE_IDENTITY() END然后select * from testtable with (NOLOCK)我的結果顯示:2009-04-03 15:41:27.*377*為DateField列。任何想法為什么我似乎失去了一毫秒?
為什么SQL Server會丟失一毫秒?
慕容708150
2019-09-03 19:20:32