sql - 将十进制（12、95）转换为SQL Server中的单词(Convert Decimal (12, 95) to words in SQL Server)

Question

I need a function that convert from decimal to words in sql server, like so 12.95 = twelve dot ninety-five.

(我需要一个在SQL Server中从十进制转换为单词的函数，例如12.95 =十二点九十五。)

Someone can help me find one.

(有人可以帮我找到一个。)

I was doing some research but what I found is not what I need.

(我正在做一些研究，但发现不是我所需要的。)

This one of the post i found: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/088770e3-927a-4e3e-854f-fdfa3f08dd55/convert-numberscurrency-to-words?forum=transactsql

(我发现的这篇文章之一： https : //social.msdn.microsoft.com/Forums/sqlserver/en-US/088770e3-927a-4e3e-854f-fdfa3f08dd55/convert-numberscurrency-to-words?forum=transactsql)

Another one: http://www.nullskull.com/q/10381222/procedure-or-function-to-convert-decimal-amount-in-words.aspx

(另一个： http ： //www.nullskull.com/q/10381222/procedure-or-function-to-convert-decimal-amount-in-words.aspx)

  ask by Jose Merchol Gomera Olmos translate from so

Answer 1

等待大神答复