sql server数据库实现保留指定位数小数的函数
USE [数据库名称]GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create function .(@strength numeric(20,6),@numlimit int)
Returns varchar(30)
As
Begin
Declare @avg numeric(20,6)
Declare @avgStr varchar(30)
Set @avg= round(@strength,@numlimit)
Set @avgStr= convert(varchar(30),@avg)
if @numlimit=0
set@avgStr = substring(@avgStr,0,len(@avgStr)-6)
if @numlimit>0
set @avgStr = substring(@avgStr,0,len(@avgStr)-5+@numlimit)
Return@avgStr
End
页:
[1]