CREATE DATABASE MSSQL_FULL;
USE MSSQL_FULL;

CREATE TABLE dbo.TEST_DATASET(id INTEGER PRIMARY KEY, test_column_1 bigint,test_column_10 float,test_column_11 real,test_column_12 date,test_column_13 smalldatetime,test_column_14 datetime,test_column_15 datetime2,test_column_16 time,test_column_17 datetimeoffset,test_column_18 char,test_column_19 varchar(max) COLLATE Latin1_General_100_CI_AI_SC_UTF8,test_column_2 int,test_column_20 text,test_column_21 nchar,test_column_22 nvarchar(max),test_column_23 ntext,test_column_24 binary,test_column_25 varbinary(3),test_column_26 geometry,test_column_27 uniqueidentifier,test_column_28 xml,test_column_29 geography,test_column_3 smallint,test_column_30 hierarchyid,test_column_31 sql_variant,test_column_4 tinyint,test_column_5 bit,test_column_6 DECIMAL(5,2),test_column_7 numeric,test_column_8 money,test_column_9 smallmoney );

INSERT INTO dbo.TEST_DATASET VALUES (1, -9223372036854775808, '123', '123', '0001-01-01', '1900-01-01', '1753-01-01', '0001-01-01', null, '0001-01-10 00:00:00 +01:00', 'a', 'a', null, 'a', 'a', 'a', 'a', CAST( 'A' AS BINARY(1)), CAST( 'ABC' AS VARBINARY), geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180)', 0), '375CFC44-CAE3-4E43-8083-821D2DF0E626', '<user><user_id>1</user_id></user>', geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656 )', 4326), null, '/1/1/', 'a', null, null, 999.33, '99999', null, null);
INSERT INTO dbo.TEST_DATASET VALUES (2, 9223372036854775807, '1234567890.1234567', '1234567890.1234567', '9999-12-31', '2079-06-06', '9999-12-31', '9999-12-31', '13:00:01', '9999-01-10 00:00:00 +01:00', '*', 'abc', -2147483648, 'abc', '*', 'abc', 'abc', null, null, null, null, null, null, -32768, null, 'abc', 0, 0, null, null, '9990000.3647', '-214748.3648');
INSERT INTO dbo.TEST_DATASET VALUES (3, 0, null, null, '1999-01-08', null, '9999-12-31T13:00:04Z', '9999-12-31T13:00:04.123456Z', '13:00:04Z', null, null, N'Миші йдуть на південь, не питай чому;', 2147483647, 'Some test text 123$%^&*()_', N'ї', N'Миші йдуть на південь, не питай чому;', N'Миші йдуть на південь, не питай чому;', null, null, null, null, '', null, 32767, null, N'Миші йдуть на південь, не питай чому;', 255, 1, null, null, null, 214748.3647);
INSERT INTO dbo.TEST_DATASET VALUES (4, null, null, null, null, null, '9999-12-31T13:00:04.123Z', null, '13:00:04.123456Z', null, null, N'櫻花分店', null, '', null, N'櫻花分店', N'櫻花分店', null, null, null, null, null, null, null, null, N'櫻花分店', null, 'true', null, null, null, null);
INSERT INTO dbo.TEST_DATASET VALUES (5, null, null, null, null, null, null, null, null, null, null, '', null, null, null, '', '', null, null, null, null, null, null, null, null, '', null, 'false', null, null, null, null);
INSERT INTO dbo.TEST_DATASET VALUES (6, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO dbo.TEST_DATASET VALUES (7, null, null, null, null, null, null, null, null, null, null, N'\xF0\x9F\x9A\x80', null, null, null, N'\xF0\x9F\x9A\x80', N'\xF0\x9F\x9A\x80', null, null, null, null, null, null, null, null, N'\xF0\x9F\x9A\x80', null, null, null, null, null, null);