Mostly Bollogs, I'm afraid

But occasionally, a glimmer of truth.
If you find one, please let me know.



Friday 23 May 2014

SQLSERVER

Script:

DROP TABLE EVENTS;
CREATE TABLE EVENTS(MAC bigint NOT NULL, Node tinyint, Datim DateTime NOT NULL,
Type tinyint NOT NULL, Event smallint NOT NULL, Status tinyint NOT NULL);
Insert into events(MAC, Node, Datim, Type, Event, Status) values(0x123456789abc, 4, '2014-05-13 13:25:30:001', 1, 27, 1);
Insert into events(MAC, Node, Datim, Type, Event, Status) values(0x123456789abc, 4, '2014-05-13 13:25:30:002', 1, 27, 1);
select * from events;

Results:

20015998343868 4 2014-05-13 13:25:30.000 1 27 1
20015998343868 4 2014-05-13 13:25:30.003 1 27 1

Why?