float vs decimal
SET @Float1 = 54;
SET @Float2 = 3.1;
SET @Float3 = 0 + @Float1 + @Float2;
SELECT @Float3 - @Float1 - g@Float2 AS "Should be 0";

DECLARE @Float1 decimal(8,3), @Float2 decimal(8,3), @Float3 decimal(8,3), @Float4 decimal(8,3);
SET @Float1 = 54;
SET @Float2 = 3.1;
SET @Float3 = 0 + @Float1 + @Float2;
SELECT @Float3 - @Float1 - @Float2 AS "Should be 0";

No comments:
Post a Comment