类型转换
1 --===========================类型转换============================= 2 3 select CAST(100 as varchar(10)) + 'hello' 4 select convert(varchar(10),100) + 'hello' 5 select CONVERT(varchar(50),getdate(),101) 6 select * from test order by CAST(myid as int) desc