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

)

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.148,

99283.132)