34,838
社区成员




DECLARE @f1 FLOAT
SET @f1 = 1.575
SELECT @f1 ,
ROUND(@f1, 2)
DECLARE @f2 FLOAT
SET @f2 = 1.475
SELECT @f2 ,
ROUND(@f2, 2)
DECLARE @f3 FLOAT
SET @f3 = 1.275
SELECT @f3 ,
ROUND(@f3, 2)
DECLARE @f1 decimal(18,2)
SET @f1 = 1.575
SELECT @f1 ,
ROUND(@f1, 2)
DECLARE @f2 decimal(18,2)
SET @f2 = 1.475
SELECT @f2 ,
ROUND(@f2, 2)
DECLARE @f3 decimal(18,2)
SET @f3 = 1.175
SELECT @f3 ,
ROUND(@f3, 2)
--///////////////////
DECLARE @f1 numeric(18,2)
SET @f1 = 1.575
SELECT @f1 ,
ROUND(@f1, 2)
DECLARE @f2 numeric(18,2)
SET @f2 = 1.475
SELECT @f2 ,
ROUND(@f2, 2)
DECLARE @f3 numeric(18,2)
SET @f3 = 1.175
SELECT @f3 ,
ROUND(@f3, 2)