select CAST(t1 as int)+CAST(t2 as int) from test
t1 , t2 列名 varchar字符型
先转换为 int 型 ,再进行相加 ............
sum(cast(t1 as int)) 为该列值总和.....
select CAST(t1 as int)+CAST(t2 as int) from test
t1 , t2 列名 varchar字符型
先转换为 int 型 ,再进行相加 ............
sum(cast(t1 as int)) 为该列值总和.....