if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FormatNumber]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[FormatNumber]
Create function FormatNumber (@num int,@width int)
returns varchar(50)
as
begin
return(right(cast(power(10,@width) + @num as varchar(50)),@width))
end
print dbo.formatnumber(22,9)
输出结果:000000022