-
Notifications
You must be signed in to change notification settings - Fork 26
Expand file tree
/
Copy pathmssql.sql
More file actions
170 lines (164 loc) · 45 KB
/
Copy pathmssql.sql
File metadata and controls
170 lines (164 loc) · 45 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
create database mydb;
go
use mydb;
go
CREATE TABLE my_table (
my_nchar NCHAR(4),
my_char CHAR(4),
my_nvarchar_max NVARCHAR(MAX),
my_nvarchar NVARCHAR(50),
my_varchar_max VARCHAR(MAX),
my_varchar VARCHAR(50),
my_empty_varchar VARCHAR(50),
my_ntext NTEXT,
my_text TEXT,
my_bigint BIGINT,
my_int INT,
my_smallint SMALLINT,
my_tinyint TINYINT,
my_float FLOAT,
my_real REAL,
my_decimal DECIMAL(10, 5),
my_money MONEY,
my_smallmoney SMALLMONEY,
my_datetime2 DATETIME2,
my_datetime DATETIME,
my_smalldatetime SMALLDATETIME,
my_datetimeoffset DATETIMEOFFSET,
my_date DATE,
my_time TIME,
my_binary BINARY(50),
my_varbinary VARBINARY(MAX),
my_image IMAGE,
my_bit BIT,
my_uniqueidentifier UNIQUEIDENTIFIER,
my_xml XML
);
go
DECLARE @counter INT;
SET @counter = 1;
WHILE @counter <= 1000
BEGIN
INSERT INTO my_table (my_nchar, my_char, my_nvarchar_max, my_nvarchar, my_varchar_max, my_varchar, my_empty_varchar, my_ntext, my_text, my_bigint, my_int, my_smallint, my_tinyint, my_float, my_real, my_decimal, my_money, my_smallmoney, my_datetime2, my_datetime, my_smalldatetime, my_datetimeoffset, my_date, my_time, my_binary, my_varbinary, my_image, my_bit, my_uniqueidentifier, my_xml)
VALUES
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>'),
(N'ABCD', 'ABCD', N'This is a "test" message', N'Test message', 'This is a ''test'' message', 'Test message', '', N'Test ntext', 'Test text', 123456789, 12345, 123, 12, 123.45, 123.45, 123.43, 123.45, 123.45, '2023-07-23T14:30:00.7654321', '2023-07-23T14:30:00.765', '2023-07-23T14:30:00', '2023-07-23T14:30:00.7654321-07:00', '2023-07-23', '14:30:00', 0x010101, 0x010101, 0x010101, 1, NEWID(), '<root><test>Some XML data</test></root>');
SET @counter = @counter + 1;
END;
go
-- Second row with all NULLs
INSERT INTO my_table (
my_nchar, my_char, my_nvarchar_max, my_nvarchar, my_varchar_max,
my_varchar, my_ntext, my_text, my_bigint, my_int, my_smallint,
my_tinyint, my_float, my_real, my_decimal, my_money, my_smallmoney,
my_datetime2, my_datetime, my_smalldatetime, my_datetimeoffset,
my_date, my_time, my_binary, my_varbinary, my_image, my_bit,
my_uniqueidentifier, my_xml
-- my_hierarchyid, my_sql_variant,
-- my_geometry, my_geography
)
VALUES (
NULL, NULL, 'one not 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
);
go