新增文章

文章标题分类内容

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】【删除】

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.aNum') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
               DROP     FUNCTION                                       dbo.aNum
   GO
   
   
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 select  dbo.aNum( 35 ,5 ,'0' ) 【流水号】【序号】【补零】

create function dbo.aNum
   (
       @Int    int
      ,@Count  int
      ,@Txt    varchar(10) 
   )
   returns varchar(200) 
   as 
   begin
   ---------------------------------------------------------------------------------------------------------------------------------------------
      declare @Txt1 varchar(50) ;   set @Txt1 = '' ;
      
      while len(@Txt1) < @Count - len(@Int)
      begin
         set @Txt1 = @Txt1 + @Txt ;
      end
      
      return @Txt1 + convert( varchar(50) ,@Int ) ;
   end
   
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/* 调用：

select  dbo.aNum( 35 ,5 ,'0' )   -- 流水号 35 / 5位数 / 前面 + 0 / 结果 00035
   select  dbo.aNum( 35 ,5 ,'x' )   -- 流水号 35 / 5位数 / 前面 + x / 结果 xxx35
   
   select  dbo.aNum( 123456 ,5 ,'0' )   -- 流水号 123456 / 5位数 / 前面 + 0 / 结果 123456
   
*/