简单问题在线等~

[hj3793]

Declare @PN decimal
Set @PN = 1.6
Select cast(@PN as varchar)

------------------

怎么改才能输出结果是1.6，并且是字符型的？

[paoluo]

Declare @PN decimal(10, 1)
Set @PN = 1.6
Select cast(@PN as varchar)

[chuifengde]

Declare @PN decimal(10,1)
Set @PN = 1.6
select @pn
Select str(@PN,10,1)

[paoluo]

問題出在你的第一句上

Declare @PN decimal
Set @PN = 1.6
Select @PN

[hj3793]

谢谢,我测试一下

[paoluo]

Declare @PN2 decimal
Set @PN2 = 1.6
Select @PN2

Declare @PN1 decimal(10, 1)
Set @PN1 = 1.6
Select cast(@PN1 as varchar)
--Result
/*
2

1.6
*/

[hj3793]

谢谢楼上的，等我写完去掉尾部为0的函数后马上结帖

[hj3793]

Create Function ClearEnd
(
@Str varchar(20)
)
/*
该函数去掉字符串尾部的 0
例如 ClearEnd('2.000') 为 2
ClearEnd('2.010') 为 2.01
*/
Returns varchar(20)
As
Begin
Declare @Len int
Set @Len = Len(@Str)
while(@Len > 0)
Begin
if(Right(@Str,1) = '0')
Set @Str = Left(@Str,Len(@Str)-1)
else
break
End
if(Right(@Str,1) = '.')
Set @Str = Left(@Str,Len(@Str)-1)
return @Str
End
-----------------------------------
嘿嘿，结合一起用就好了，结帖