Back to OIM Explorer

dbo.QBM_FCVJobParameterToList_cl

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.868 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVJobParameterToList source text reference

References

Referenced By

Complete Source

SQL91 lines
1CREATE FUNCTION dbo.QBM_FCVJobParameterToList_cl(2  @paramin nvarchar(max)3) RETURNS @parameters TABLE(SortOrder int identity,4ParameterName nvarchar(200) collate database_Default,5ParameterValue nvarchar(max) collate database_Default,6isCrypted BIT,7isHidden BIT8)9  WITH schemabinding10AS11BEGIN12  DECLARE @len int13  SELECT14    @len = len(isnull(@paramin, ''))15  DECLARE @posi int16  SELECT @posi = 117  DECLARE @lenElem int18  DECLARE @ParameterName nvarchar(200)19  DECLARE @ParameterValue nvarchar(max)20  DECLARE @crypthide nvarchar(100)21  DECLARE @isCrypted BIT22  DECLARE @ishidden BIT23  IF @len < 224  BEGIN25    GOTO ende26  END27  IF substring(@paramin,28  @posi,29  1) <> N '~'30  BEGIN31    GOTO ende32  END33  SELECT @posi = 234  WHILE @posi <= @len35  BEGIN36    SELECT37      @lenelem = convert(int,38      substring(@paramin, @posi, charindex(N '~', substring(@paramin, @posi, 10)) -1))39    SELECT @posi = @posi + len(trim(str(@lenelem))) + 140    SELECT41      @ParameterName = substring(@paramin,42      @posi,43      @lenelem)44    SELECT @Posi = @posi + @lenelem +145    SELECT46      @lenelem = convert(int,47      substring(@paramin, @posi, charindex(N '~', substring(@paramin, @posi, 10)) -1))48    SELECT @posi = @posi + len(trim(str(@lenelem))) + 149    SELECT50      @ParameterValue = substring(@paramin,51      @posi,52      @lenelem)53    SELECT @Posi = @posi + @lenelem +154    SELECT55      @lenelem = convert(int,56      substring(@paramin, @posi, charindex(N '~', substring(@paramin, @posi, 10)) -1))57    SELECT @posi = @posi + len(trim(str(@lenelem))) + 158    SELECT59      @crypthide = substring(@paramin,60      @posi,61      @lenelem)62    SELECT @Posi = @posi + @lenelem +163    IF @crypthide LIKE N '%Crypted%'64    BEGIN65      SELECT @isCrypted = 166    END67    ELSE68    BEGIN69      SELECT @isCrypted = 070    END71    IF @crypthide LIKE N '%Hidden%'72    BEGIN73      SELECT @isHidden = 174    END75    ELSE76    BEGIN77      SELECT @isHidden = 078    END79    INSERT INTO @parameters(ParameterName,80    ParameterValue,81    isCrypted,82    isHidden)83    SELECT84      @ParameterName,85      @ParameterValue,86      @isCrypted,87      @isHidden88  END89  ende:90  RETURN91END
Open raw exported source
SQL ยท Raw14 lines
1create function dbo.QBM_FCVJobParameterToList_cl (@paramin nvarchar(max)) returns @parameters table(SortOrder int identity, ParameterName nvarchar(200)2 collate database_Default, ParameterValue nvarchar(max) collate database_Default, isCrypted bit, isHidden bit ) with schemabinding as begin declare @len3 int select @len = len(isnull(@paramin, '')) declare @posi int select @posi = 1 declare @lenElem int declare @ParameterName nvarchar(200) declare @ParameterValue4 nvarchar(max) declare @crypthide nvarchar(100) declare @isCrypted bit declare @ishidden bit if @len < 2 begin  goto ende end if substring(@paramin, @posi5, 1) <> N'~' begin  goto ende end select @posi = 2 while @posi <= @len begin  select @lenelem = convert(int, substring(@paramin, @posi, charindex(N'~',6 substring(@paramin, @posi, 10)) -1 ))  select @posi = @posi  + len(trim(str(@lenelem))) + 1 select @ParameterName = substring (@paramin, @posi, @lenelem7) select @Posi = @posi + @lenelem +1  select @lenelem = convert(int, substring(@paramin, @posi, charindex(N'~', substring(@paramin, @posi, 10)) -1 )) select8 @posi = @posi  + len(trim(str(@lenelem))) + 1 select @ParameterValue = substring (@paramin, @posi, @lenelem) select @Posi = @posi + @lenelem +1  select9 @lenelem = convert(int, substring(@paramin, @posi, charindex(N'~', substring(@paramin, @posi, 10)) -1 )) select @posi = @posi  + len(trim(str(@lenelem10))) + 1 select @crypthide = substring (@paramin, @posi, @lenelem) select @Posi = @posi + @lenelem +1 if @crypthide like N'%Crypted%' begin select @isCrypted11 = 1 end else begin select @isCrypted = 0 end if @crypthide like N'%Hidden%' begin select @isHidden = 1 end else begin select @isHidden = 0 end insert 12into @parameters (ParameterName, ParameterValue, isCrypted, isHidden) select @ParameterName, @ParameterValue, @isCrypted, @isHidden  end ende: return end13 14