20000.00
154248.25 要求输出格式为17位不带小数点
00000000002000000
00000000015424825 有人推荐
select right('0000000000'+ltrim(金额*100),17) from tb
但无法实现请指点哈,急用
154248.25 要求输出格式为17位不带小数点
00000000002000000
00000000015424825 有人推荐
select right('0000000000'+ltrim(金额*100),17) from tb
但无法实现请指点哈,急用
--可以啊
declare @a numeric,@b numericset @a = 20000.00
set @b = 154248.25 print right('0000000000'+ltrim(@a*100),17)
print right('0000000000'+ltrim(@b*100),17)
insert into tb values(20000.00)
insert into tb values(154248.25)
goselect right('0000000000000000' + cast(cast(id*100 as int) as varchar),17) from tb
/*
----------------------------------
00000000002000000
00000000015424825(所影响的行数为 2 行)
*/select right('0000000000000000' + ltrim(cast(id*100 as int)),17) from tb
/*
----------------------------------
00000000002000000
00000000015424825(所影响的行数为 2 行)
*/drop table tb