DROP TABLE TEST1
CREATE TABLE TEST1 (
    ID                  CHAR(4),
    TINYINT_ITEM        TINYINT,
    SMALLINT_ITEM       SMALLINT,
    INT_ITEM            INT,
    BIGINT_ITEM         BIGINT,
    BIT_ITEM            BIT,
    DECIMAL_ITEM        DECIMAL(12,2),
    NUMERIC_ITEM        NUMERIC(5,3),
    SMALLMONEY_ITEM     SMALLMONEY,
    MONEY_ITEM          MONEY,
    REAL_ITEM           REAL,
    FLOAT_ITEM          FLOAT,
    CHAR_ITEM           CHAR(4),
    VARCHAR_ITEM        VARCHAR(8),
    TEXT_ITEM           TEXT,
    NCHAR_ITEM          NCHAR(4),
    NVARCHAR_ITEM       NVARCHAR(8),
    NTEXT_ITEM          NTEXT,
    DATE_ITEM           DATE,
    DATETIME_ITEM       DATETIME,
    DATETIME2_ITEM      DATETIME2,
    DATETIME2_2_ITEM    DATETIME2(2),
    SMALLDATETIME_ITEM  SMALLDATETIME,
    TIME_ITEM           TIME,
    TIME_2_ITEM         TIME(2),
    PRIMARY KEY (ID)
);
INSERT INTO TEST1(ID) VALUES('1000');
INSERT INTO TEST1 VALUES(
    '1001',
    12,
    1234,
    123456,
    12345678901234,
    1,
    1234567890.12,
    12.345,
    12.3456,
    1234.5678,
    1234567.8,
    123456789012.34,
    'a',
    'A',
    'abcdefg',
    'あ',
    'ア',
    'あいうえお',
    '2018-01-02',
    '2018-01-03 12:34:56.789',
    '2018-01-04 12:34:56.1234567',
    '2018-01-05 12:34:56.89',
    '2018-01-06 12:34:56',
    '17:34:56.1234567',
    '18:34:56.12'
);