select * from TableName order by cast(colName as int);
select * from TableName order by convert(int,colName);
sqlserver中将varchar类型转换为int型
最新推荐文章于 2024-07-06 03:44:31 发布
select * from TableName order by cast(colName as int);
select * from TableName order by convert(int,colName);