Back to OIM Explorer

dbo.QBM_FCVStringPadLeft

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 431 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL29 lines
1CREATE FUNCTION dbo.QBM_FCVStringPadLeft(2  @In nvarchar(max),3  @MaxLength int,4  @FillChar nvarchar(1)5) RETURNS nvarchar(max6)7  WITH SCHEMABINDING8AS9BEGIN10  DECLARE @erg nvarchar(max)11  DECLARE @len int12  SELECT13    @len = len(isnull(@in, N ''))14  IF @len >= @MaxLength15  BEGIN16    SELECT17      @erg = isnull(@in,18      N '')19  END20  ELSE21  BEGIN22    SELECT23      @erg = replicate(isnull(@fillchar, N ''),24      @MaxLength - @len) + isnull(@in,25      N '')26  END27  ende:28  RETURN(@erg)29END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FCVStringPadLeft ( @In nvarchar(max) , @MaxLength int , @FillChar nvarchar(1) ) returns nvarchar(max) with SCHEMABINDING2 as begin declare @erg nvarchar(max) declare @len int select @len = len(isnull(@in, N'')) if @len >= @MaxLength begin select @erg = isnull(@in, N'') end3 else begin select @erg = replicate(isnull(@fillchar, N''), @MaxLength - @len)+ isnull(@in, N'') end  ende: return(@erg) end 4