数据库中有个float字段 数据如下
a (列名)
132165.0165464
5465.5401
25.465465
1.000
怎么处理才能返回如下整数的结果集
a (列名)
132165
5465
25
1
------解决方案--------------------------------------------------------
declare @talbe1 table(a float)
insert into @talbe1 select 132165.0165464
union select 5465.5401
union select 25.465465
union select 1.000
select a=cast(a as int) from @talbe1
--结果-----------------
1
25
5465
132165
------解决方案--------------------------------------------------------
厉害～学习了