DECLARE @n1 DECIMAL(38,20), @n2 DECIMAL(38,20), @n3 REAL, @n4 REAL, @n5 DOUBLE PRECISION, @n6 DOUBLE PRECISIONSELECT @n1 = 123.4567, @n2 = 0.001SELECT @n3 = @n1, @n4 = @n2, @n5 = @n1, @n6 = @n2SELECT n_decimal = CONVERT(VARCHAR, @n1 * @n2), n_real = CONVERT(VARCHAR, @n3 * @n4), n_double = CONVERT(VARCHAR, @n5 * @n6)GO

(1 row affected)(1 row affected) n_decimal n_real n_double ------------------------------ ------------------------------ ------------------------------ 0.1234567000000000000000000000 .12345670908689499 .1234567(1 row affected)

CREATE TABLE dbo.Example( col1 DECIMAL(9,4) NULL, col2 DECIMAL(9,4) NULL, col3 AS col1 * col2)GOEXECUTE sys.sp_columns @table_owner = N'dbo', @table_name = N'Example', @column_name = N'col3'