MSSQL只显示实际的小数位(不显示.0)数据库存储136.784000,业务需求只显示 136.784,136.000000,显示136
--3位小数示例 Declare @Qty Numeric (15, 6); Set @Qty = 136.784000; Select Case When Cast(@Qty As Float) > Cast(Cast(@Qty As Float) As Int) Then Cast(@Qty As Float) Else Cast(Cast(@Qty As Float) As Int) End; --无小数示例 Declare @Qty Numeric (15, 6); Set @Qty = 136.000000; Select Case When Cast(@Qty As Float) > Cast(Cast(@Qty As Float) As Int) Then Cast(@Qty As Float) Else Cast(Cast(@Qty As Float) As Int) End;
共有条评论 网友评论