把数据库里的数据小数点后第二位四舍五入 有个超市数据库会员价字段名为vip_price,录入资料后把好多会员价精确到了分,现在想把分四舍五入请教用语句怎么改表名t_bd_item_info会员价字段vip_price例如要把5.66 改为5.7 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update t_bd_item_info set vip_price = cast(vip_price as decimal(18,1)) create table t_bd_item_info(vip_price decimal(18,2))insert into t_bd_item_info values(5.66)insert into t_bd_item_info values(5.65)insert into t_bd_item_info values(5.63)goupdate t_bd_item_info set vip_price = cast(vip_price as decimal(18,1))select * from t_bd_item_infodrop table t_bd_item_info/*vip_price -------------------- 5.705.705.60(所影响的行数为 3 行)*/ select convert(numeric(10,1), 12.25) -- 12.3 update t_bd_item_info set vip_price = cast(vip_price as decimal(18,1))select convert(numeric(10,1), 12.25) -- 12.3 SELECT cast(15.578 AS DECIMAL(10,1)) aSELECT cast(15.548 AS DECIMAL(10,1)) aa---------------------------------------15.6(1 row(s) affected)a---------------------------------------15.5(1 row(s) affected) --假设都是两位的小数位select * from tb where right(cast(col as varchar),1) <> 0 select convert(numeric(10,1), 12.27) SQL2005同步复制问题 sqlservr.exe自动增长 字符串问题 多谢谁能帮我优化个SQL~! 权限继承触发器怎么写?感觉有点不好写,谢谢 关于用提取两张关联表不重复的数据问题 请教进销存数据库设计的问题,高分~~ 分区视图的的数据插入问题 急问??如何将带参数的查询付给另一个参数阿 一个关于取得储存过程返回值问题求教 JDBC连接MSSQL2000的疑问(想了好多天都想不明白)??? oracle序列和sqlserver自增有什么区别
insert into t_bd_item_info values(5.66)
insert into t_bd_item_info values(5.65)
insert into t_bd_item_info values(5.63)
goupdate t_bd_item_info set vip_price = cast(vip_price as decimal(18,1))select * from t_bd_item_info
drop table t_bd_item_info/*
vip_price
--------------------
5.70
5.70
5.60(所影响的行数为 3 行)
*/
select convert(numeric(10,1), 12.25) -- 12.3
---------------------------------------
15.6(1 row(s) affected)a
---------------------------------------
15.5(1 row(s) affected)
select * from tb where right(cast(col as varchar),1) <> 0
select convert(numeric(10,1), 12.27)