Home >Database >Mysql Tutorial >sqlserver中将varchar类型转换为int型

sqlserver中将varchar类型转换为int型

WBOY
WBOYOriginal
2016-06-07 14:57:372912browse

无详细内容 无 select * from yourtable order by cast(yourcol as int); select * from yourtable order by convert(int,yourcol);

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

select * from yourtable order by convert(int,yourcol); 
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:ora01747Next article:Oracle存储过程分离表中的数据