sqlserver中将varchar类型转换为int型

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

select * from yourtable order by cast(yourcol as int); 

select * from yourtable order by convert(int,yourcol);