常用sql自定义函数

--把数字转为千分位格式的字符串显示，调用如 select dbo.f_splitstr(11111111111111)

CREATE FUNCTION  [dbo].[f_splitstr](

    @str varchar(8000)
)
RETURNS nvarchar(500)
AS
BEGIN
declare @lenNum int
 set @lenNum= len(@str)
 declare @nodeIndex int
 if(@lenNum>3)
 set @str=STUFF(@str,@lenNum-2,0,',')
 if(@lenNum>6)
 set @str=STUFF(@str,@lenNum-5,0,',')
 if(@lenNum>9)
 set @str=STUFF(@str,@lenNum-8,0,',')
 if(@lenNum>12)
 set @str=STUFF(@str,@lenNum-11,0,',')
 return @str
END