我想让varchar 类型的数据按照 int类型的数据排序 我varchar字段中保存的只有数字
select * from result order by turnover desc;是可以查询
select * from result order by convert(int,turnover) desc;换成这行就报错了
敬请指点
select * from result order by turnover desc;是可以查询
select * from result order by convert(int,turnover) desc;换成这行就报错了
敬请指点
select * from result order by 0+turnover desc
from result
order by (turnover+0) desc
所以,楼主的程序肯定会报错。
楼主应该用cast() 函数。