create proc wf
(
@num1 money
)
as
begin
select cast(@num1 as varchar)
end

select cast(convert(float,@num1) as varchar(10))
--or
select cast(convert(decimal(18,3),@num1) as varchar(10))

------解决方案--------------------
探讨


select 
convert(varchar(30),@num1 ,0)


------解决方案--------------------
SQL code
-- 保留四位
ALTER  proc wf
(
@num1 money
)
as
begin

select convert(VARCHAR(10),@num1 ,126)
end

------解决方案--------------------
探讨


引用:

select
convert(varchar(30),@num1 ,0)


0 改成1  还有三位一瞥的功效


------解决方案--------------------

cast((cast(@num1 as numeric(18, 4))) as varchar)