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
|
SELECT "char(10)" = convert(char(10), "test")
SELECT "varchar(10)" = convert(varchar(10), "test")
CREATE TABLE dsp_test (
char_col char(10) null,
vchar_col varchar(10) null,
bin_col binary(4) null,
text_col text null,
image_col image null,
tiny_col tinyint null,
small_col smallint null,
int_col int null,
real_col real null,
float_col float null,
bit_col bit not null,
dt_col datetime null,
sdt_col smalldatetime null,
money_col money null,
smoney_col smallmoney null,
num_col numeric(12,3) null,
dec_col numeric(12,3) null
)
go
INSERT INTO dsp_test VALUES (
"test",
"testtest",
0x12345678,
"this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.this is an example of data in a text column, I just need to make sure that the contents of this column exceeds two hundred and fify five characters.",
0x123456,
15,
99,
23938,
3.14837,
99283.1328273,
1,
getdate(),
"11/03/69 04:35am",
$1237362.32,
$1233.99,
3.14837,
99283.1328273)
go
|
