sql server:float转换成nvarchar

select convert(nvarchar(30),convert(decimal(11,0),Mobile)) mobile,studentname from yuanboguojistudent_excel WHERE mobile IS NOT NULL 
原文地址:https://www.cnblogs.com/panqingqiang/p/4543859.html