sql-server - 在分子和/或分母中添加转换为小数？

Question

演员阵容如何改变除法结果？还是我应该两个都投？

select 1/(cast(3 as decimal(6,2)))
select (cast(1 as decimal(6,2)))/3
select (cast(1 as decimal(6,2)))/(cast(3 as decimal(6,2)))

select 4/(cast(3 as decimal(6,2)))
select (cast(4 as decimal(6,2)))/3
select (cast(4 as decimal(6,2)))/(cast(3 as decimal(6,2)))
select 220020212/(cast(3 as decimal(6,2)))

退货

0.3333333
0.333333
0.333333333
1.3333333
1.333333
1.333333333
73340070.6666666

标签： sql-servertsql

Answer 1

我喜欢先将列设置为数字，这样我就不必将它们转换为小数。

SELECT 
[COL1]/[COL2]
FROM(
SELECT [COL1] = CAST(1 AS NUMERIC), [COL2] = CAST(2 AS NUMERIC)) AS [SUB1]