如何将两个varchar值相加 [英] How to sum two varchar value

问题描述

我必须将字段命名为field1和field2，两个数据类型都是varchar。我怎样才能得到两列的总和。请帮帮我。

解决方案

你可以看看这个

sql-server-how-to-sum-a-varchar-column [ ^ ]

除非你进行转换，否则你不能。注意：无法将整个数据转换为数值。这就是转换失败的原因。


请参阅： CAST和CONVERT（T-SQL） [ ^ ]



顺便说一下：如果您将数字数据存储为varchar，则意味着：糟糕的表格设计。我建议你重新设计你的桌子。

I have to field named field1 and field2 and both data type is varchar. How can I get the summation of the two column. Please help me.

解决方案

You can have a look at this
sql-server-how-to-sum-a-varchar-column[^]

You can't unless you make conversion. Note: It's not possible to convert entire data into numeric value. That's why conversion could failed.

Please, see: CAST and CONVERT (T-SQL)[^]

By The Way: If yoou store numeric data as a varchar, it means: bad table design. I would recommend you to re-design your table.

这篇关于如何将两个varchar值相加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！