表mytable
id(int) name(varchar(20))
1 aa
2 bb
3 cc 怎么样才能得到这样的结果
newtitle
1aa
2bb
3ccselect (id+name) as newtitle from mytable
出现如下错误。将数据类型 varchar 转换为 int 时出错。
id(int) name(varchar(20))
1 aa
2 bb
3 cc 怎么样才能得到这样的结果
newtitle
1aa
2bb
3ccselect (id+name) as newtitle from mytable
出现如下错误。将数据类型 varchar 转换为 int 时出错。
select (cast(id as varchar(100))+name) as newtitle from mytable