Back to OIM Explorer

dbo.QBM_FCVStringTrimRight

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 835 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

SQL45 lines
1CREATE FUNCTION dbo.QBM_FCVStringTrimRight(2  @In nvarchar(max),3  @TrimChars nvarchar(64),4  @CaseSensitive BIT = 05) RETURNS nvarchar(max6)7  WITH SCHEMABINDING8AS9BEGIN10  DECLARE @erg nvarchar(max)11  DECLARE @TrimChars_intern nvarchar(100)12  SELECT13    @trimchars_intern = isnull(@TrimChars,14    N '')15  SELECT @trimchars_intern = N '%' + @trimchars_intern + N '%'16  SELECT17    @erg = isnull(@in,18    N '')19  IF @CaseSensitive = 120  BEGIN21    WHILE len(@erg) > 0 AND @trimchars_intern LIKE N '%' + substring(@erg,22    len(@erg),23    1) + N '%' collate SQL_Latin1_General_CP1_CS_AS24    BEGIN25      SELECT26        @erg = substring(@erg,27        1,28        len(@erg) -1)29    END30  END31  ELSE32  BEGIN33    WHILE len(@erg) > 0 AND @trimchars_intern LIKE N '%' + substring(@erg,34    len(@erg),35    1) + N '%' collate SQL_Latin1_General_CP1_CI_AS36    BEGIN37      SELECT38        @erg = substring(@erg,39        1,40        len(@erg) -1)41    END42  END43  ende:44  RETURN(@erg)45END
Open raw exported source
SQL · Raw7 lines
1  create   function dbo.QBM_FCVStringTrimRight ( @In nvarchar(max) , @TrimChars nvarchar(64) , @CaseSensitive bit = 0 ) returns nvarchar(max) with2 SCHEMABINDING as begin declare @erg nvarchar(max)  declare @TrimChars_intern nvarchar(100) select @trimchars_intern = isnull(@TrimChars, N'') select @trimchars_intern3 = N'%' + @trimchars_intern + N'%' select @erg = isnull(@in, N'') if @CaseSensitive = 1 begin while len(@erg) > 0 and @trimchars_intern like N'%' + substring4(@erg, len(@erg), 1) + N'%' collate SQL_Latin1_General_CP1_CS_AS  begin select @erg = substring(@erg, 1, len(@erg) -1 ) end end else begin while len(@erg5) > 0 and @trimchars_intern like N'%' + substring(@erg, len(@erg), 1) + N'%' collate SQL_Latin1_General_CP1_CI_AS  begin select @erg = substring(@erg, 61, len(@erg) -1 ) end end ende: return(@erg) end 7