昨夜看到谁谁的数字转英文帖子, 咋不见了?!
做了两个函数,实现帖子上说的数字转英文.
当散分了!

SQL code

-- =============================================-- Author:        Author,qianjin036a-- Create date: Create Date,06/14/2008 02:27:17-- Description:    Description,Arabic numerals to English-- =============================================CREATE FUNCTION Digit2English (@arabia decimal(38,17))RETURNS varchar(1000)ASBEGIN    declare @atoe table(a int,e varchar(10))    insert into @atoe select 0,'zero'    union all select 1,'one'        union all select 2,'two'            union all select 3,'three'    union all select 4,'four'            union all select 5,'five'    union all select 6,'six'            union all select 7,'seven'    union all select 8,'eight'            union all select 9,'nine'    declare @integer bigint,@trillion int,@billion int,@million int,@thousand int,@hundred int,@english varchar(1000)    select @integer=@arabia,@english=''    select @trillion=@integer % 1000000000000000/1000000000000,@billion=@integer % 1000000000000/1000000000,        @million=@integer % 1000000000/1000000,@thousand=(@integer % 1000000)/1000,@hundred=(@integer % 1000)    if @trillion>0        set @english=@english + dbo.ThreeDigit(@trillion) + 'trillion '    if @billion>0        set @english=@english + dbo.ThreeDigit(@billion) + trust_bs,

[解决办法]
sf
[解决办法]
很强大．
[解决办法]
强！
[解决办法]
牛
[解决办法]
很强大
[解决办法]
...................
[解决办法]
收藏先
[解决办法]
...
[解决办法]
up
[解决办法]
呵呵~~
[解决办法]
支持

感谢分享
[解决办法]
强悍
支持
分享

[解决办法]
收藏
[解决办法]
分～～