CREATE TABLE SMALLDATETIME_dt (a SMALLDATETIME)
prepst#!# INSERT INTO SMALLDATETIME_dt(a) values(@a) #!#SMALLDATETIME|-|a|-|2000-12-13 12:58:23
prepst#!#exec#!#SMALLDATETIME|-|a|-|2007-05-08 12:35:29
prepst#!#exec#!#SMALLDATETIME|-|a|-|2007-05-08 12:35:30
prepst#!#exec#!#SMALLDATETIME|-|a|-|2007-05-08 12:59:59.998
prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-02-28 23:59:59.999
prepst#!#exec#!#SMALLDATETIME|-|a|-|1900-02-28 23:59:59.999
#prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-02-28 23:45:29.999
prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-02-28 23:45:30
prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-02-28 23:45:29
prepst#!#exec#!#SMALLDATETIME|-|a|-|1900-02-28 23:45:30
prepst#!#exec#!#SMALLDATETIME|-|a|-|1900-02-28 23:45:29
prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-12-13 12:58:30
prepst#!#exec#!#SMALLDATETIME|-|a|-|2000-02-28 23:45:29.998
prepst#!#exec#!#SMALLDATETIME|-|a|-|1900-01-01 00:00:00
prepst#!#exec#!#SMALLDATETIME|-|a|-|2079-06-06 23:59:29
prepst#!#exec#!#SMALLDATETIME|-|a|-|<NULL>
SELECT * FROM SMALLDATETIME_dt;
INSERT INTO SMALLDATETIME_dt(a) values('2000-12-13 12:58:23');
INSERT INTO SMALLDATETIME_dt(a) values('2007-05-08 12:35:29');
INSERT INTO SMALLDATETIME_dt(a) values('2007-05-08 12:35:30');
INSERT INTO SMALLDATETIME_dt(a) values('2007-05-08 12:59:59.998');
INSERT INTO SMALLDATETIME_dt(a) values('2000-02-28 23:59:59.999');
INSERT INTO SMALLDATETIME_dt(a) values('1900-02-28 23:59:59.999');
INSERT INTO SMALLDATETIME_dt(a) values('2000-02-28 23:45:29.999');
INSERT INTO SMALLDATETIME_dt(a) values('2000-02-28 23:45:30');
INSERT INTO SMALLDATETIME_dt(a) values('2000-02-28 23:45:29');
INSERT INTO SMALLDATETIME_dt(a) values('1900-02-28 23:45:29');
INSERT INTO SMALLDATETIME_dt(a) values('1900-12-13 12:58:30');
INSERT INTO SMALLDATETIME_dt(a) values('2000-02-28 23:45:29.998');
INSERT INTO SMALLDATETIME_dt(a) values('1900-01-01 00:00:00');
INSERT INTO SMALLDATETIME_dt(a) values('2079-06-06 23:59:29');
INSERT INTO SMALLDATETIME_dt(a) values(NULL);
SELECT * FROM SMALLDATETIME_dt;
DROP TABLE SMALLDATETIME_dt;