我需要将varchar数据类型为SQL列decimal并将null值转换varchar为0。这是我要转换为的代码decimal：
SELECT
CAST(debit as DECIMAL(9,2)),
CAST(credit as DECIMAL(9,2)),
sum_accname,
sum_date,
sum_description
FROM
sum_balance
我需要将借方和贷方列的空值转换为零。如何将空值转换部分插入此代码？
SELECT
COALESCE(CAST(debit as DECIMAL(9,2)),0) as debit,
COALESCE(CAST(credit as DECIMAL(9,2)),0) as credit,
sum_accname,
sum_date,
sum_description
FROM
sum_balance
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句