七郎's JavaBlog

草木竹石皆可為劒。至人之用人若鏡,不將不迎,應而不藏,故能勝物而不傷。
posts - 60, comments - 14, trackbacks - 0, articles - 0

SQL语句里将字符串转换数字类型

Posted on 2008-07-10 17:02 七郎归来 阅读(5614) 评论(0)  编辑  收藏
SQL语句里将字符串转换数字类型
select * from internal_external_rating_info order by convert(int,internal_rating)  
select * from internal_external_rating_info order by CAST(internal_rating AS INT)

只有注册用户登录后才能发表评论。


网站导航: