SET @tg=Cast (@tr as numeric (7,4))*Cast (@tg as numeric(7,4))+Cast(@tg as numeric (7,4)) Select @tg
DECLARE @num DECIMAL(7,4) SET @num = 1.1234567 SELECT @num
PRINT ROUND(1.127790001,4)
ROUND ( numeric_expression , length [ ,function ] )
SELECT ROUND(123.9994, 3), ROUND(123.9995, 3) GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)