22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE FUNCTION fn_Num(@num MONEY)
RETURNS VARCHAR(20)
AS
BEGIN
DECLARE @s VARCHAR(20)
SELECT @s=REVERSE(RTRIM(@num)),@s=STUFF(@s,1,PATINDEX('%[^0]%',@s)-1,''),@s=REVERSE((CASE WHEN @s LIKE '.%' THEN STUFF(@s,1,1,'') ELSE @s END))
RETURN @s
END
GO
SELECT dbo.fn_Num(9.400)
--9.4
DROP FUNCTION fn_Num
declare @unitprice decimal(18,4)
set @unitprice = 9.4
select @unitprice
--应该是unitprice精度的问题
cast(col as dec(18,0))