跪求高手解决sqlserver数据类型转换出错

Question

sql server数据类型 nvarchar 转换为 numeric 时出错跪求解决最好附带sql实例

Answer 1

declare @var nvarchar(200)
set @var='2004.6789'
select cast(@var as numeric(16,6))

--结果
2004.678900

select cast(@var as numeric(16,2))
--结果
2004.68