sql

1、通过类型转换查询符合要求的数据：

Select CAST(NO as varchar(50))+'deng',*From StudentInfo Where 1=1;
Select CAST(NO as float)/100,*From StudentInfo Where 1=1;