在分子和/或分母中添加十进制?

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

Answer 1

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

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