新增文章

文章标题分类内容

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

if exists ( select * from sys.objects where object_id = object_id(N'dbo.a_Space') and type in (N'FN', N'if', N'TF', N'FS', N'FT') )
               drop     function                                       dbo.a_Space
   go
   
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】dbo.a_Space( 'xxx','10cn' )  生成空格

create function dbo.a_Space
   (
       @Txt    varchar(max) 
      ,@Count  varchar(max) 
   )
   returns varchar(max) 
   as 
   begin
   ---------------------------------------------------------------------------------------------------------------------------------------------
      declare @Count1  int             set @Count1 = convert( int,dbo.a_NumTxt(@Count))
      
      declare @Count2  int             set @Count2 = @Count1 * ( case when dbo.a_EnTxt(@Count) = 'cn'then 2 else 1 end )
      declare @Space   varchar(max)  
      
      set @Space = SPACE( 
      case when dataLength( @Txt ) > @Count2 
           then 0 
           else @Count2 - dataLength( @Txt ) 
      end ) 
   ---------------------------------------------------------------------------------------------------------------------------------------------
      return isnull(@Space,'')
   end
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select dbo.a_Space( '金额(本位币)','15'   )   --【补齐空格】   3空格
   select dbo.a_Space( '金额(本位币)','15en' )   --【补齐空格】   3空格
   select dbo.a_Space( '金额(本位币)','8cn'  )   --【补齐空格】    4空格
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

declare @Count int            set @Count =  10
   declare @Txt   varchar(1000)  set @Txt   = '销售发票(专用)1:,'

select dataLength(@Txt)  个数_全角2半角1
         ,len(@Txt)         个数_不区分半角
         ,dataLength(@Txt) - len(@Txt)    中文个数
         ,len(@Txt)*2 - dataLength(@Txt)  非中文个数
         ,@Count
         ,@Count*2 - dataLength(@Txt)
         
      个数_全角2半角1	个数_不区分半角	中文个数	   非中文个数
      17	               11             	6	         5
      
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go