一.
gysid(float) note(float)
25845 11
25845 11
25845 11
26804 11
25845 11结果
2584511
2584511
2584511
2680411
2584511
二.
gysid(float) note(varchar(10))
25845 YES
25845 YES
25845 YES
26804 YES
25845 YES
结果
25845YES
25845YES
25845YES
26804YES
25845YES
gysid(float) note(float)
25845 11
25845 11
25845 11
26804 11
25845 11结果
2584511
2584511
2584511
2680411
2584511
二.
gysid(float) note(varchar(10))
25845 YES
25845 YES
25845 YES
26804 YES
25845 YES
结果
25845YES
25845YES
25845YES
26804YES
25845YES
select ltrim(gysid)+ltrim(float) from tb
二.
select ltrim(gysid)+note from tb
select ltrim(gysid)+ltrim(note) from tb
0112.00585e+006
0112.00585e+006
0112.00585e+006
0112.00585e+006
0112.0068e+006
各位得出的结果都是这个样子,还请各位帮忙看一下!
0112.00585e+006
0112.00585e+006
0112.00585e+006
0112.0068e+006
select cast (cast(gysid as decimal) as varchar) + cast (cast(note as decimal) as varchar) from table
select cast (cast(gysid as decimal) as varchar) as gysidv, cast (cast(note as decimal) as varchar) as notev from table
先把这个的结果弄出来看看