By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT CAST(124.28 AS DECIMAL(38,30)) / CAST(1039.72 AS DECIMAL(38,30))
SELECT 124.28 / 1039.72
SELECT convert(DECIMAL(38,30), 124.28) / convert(DECIMAL(38,30), 1039.72)
declare @Test1 decimal(38,30) = 124.28, @Test2 decimal(38,30) = 1039.72;
select @Test1 Test1, @Test2 Test2, @Test1 / @Test2 Test3 into #temp;
select * from #temp;
| (No column name) |
|---|
| 0.119532 |
| (No column name) |
|---|
| 0.119532181 |
| (No column name) |
|---|
| 0.119532 |
| Test1 | Test2 | Test3 |
|---|---|---|
| 124.280000000000000000000000000000 | 1039.720000000000000000000000000000 | 0.119532 |
--e1 / e2 || p1 - s1 + s2 + max(6, s1 + p2 + 1) || max(6, s1 + p2 + 1)
-- 38 - 8 + 8 max(6, 8 + * + 1) || max(6, 43)
SELECT [column] = c.name,
[type] = t.name, c.max_length, c.precision, c.scale, c.is_nullable
FROM tempdb.sys.columns AS c
INNER JOIN tempdb.sys.types AS t
ON c.system_type_id = t.system_type_id
AND t.system_type_id = t.user_type_id
WHERE [object_id] = OBJECT_ID(N'tempdb.dbo.#temp');
| column | type | max_length | precision | scale | is_nullable |
|---|---|---|---|---|---|
| Test1 | decimal | 17 | 38 | 30 | True |
| Test2 | decimal | 17 | 38 | 30 | True |
| Test3 | decimal | 17 | 38 | 6 | True |