SQL写的一个为数字补零返回补零后字符串的函数

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)asbeginreturn(right(cast(power(10,@width) + @num as varchar(50)),@width))endprint dbo.formatnumber(22,9)

输出结果：000000022