Back to OIM Explorer

dbo.QBM_FCVJobParameterToList

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 906 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_fa source text reference
  • references source dbo.QBM_FCVJobParameterToList_cl source text reference

References

Referenced By

Complete Source

SQL48 lines
1CREATE FUNCTION dbo.QBM_FCVJobParameterToList(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 BIT,8LengthCheck int9)10AS11BEGIN12  INSERT INTO @parameters(ParameterName,13  ParameterValue,14  isCrypted,15  isHidden,16  LengthCheck)17  SELECT18  LEFT(ParameterName,19  200),20  ParameterValue,21  isCrypted,22  isHidden,23  LengthCheck24  FROM dbo.QBM_FCVJobParameterToList_fa(@paramin) p25  ORDER BY p.SortOrder26  IF NOT EXISTS(27    SELECT TOP 1 128    FROM @parameters p29    WHERE30      isnull(p.LengthCheck, -1) <> 0)31  BEGIN32    RETURN33  END34  DELETE @parameters35  INSERT INTO @parameters(ParameterName,36  ParameterValue,37  isCrypted,38  isHidden,39  LengthCheck)40  SELECT41    ParameterName,42    ParameterValue,43    isCrypted,44    isHidden,45    0 AS LengthCheck46  FROM dbo.QBM_FCVJobParameterToList_cl(@paramin) EndLabel:47  RETURN48END
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.QBM_FCVJobParameterToList (@paramin nvarchar(max)) returns @parameters table(SortOrder int identity, ParameterName nvarchar(200) collate2 database_Default, ParameterValue nvarchar(max) collate database_Default, isCrypted bit, isHidden bit , LengthCheck int ) as begin insert into @parameters3 ( ParameterName, ParameterValue, isCrypted, isHidden, LengthCheck)  select left(ParameterName, 200), ParameterValue, isCrypted, isHidden, LengthCheck 4from dbo.QBM_FCVJobParameterToList_fa (@paramin) p order by p.SortOrder if not exists (select top 1 1 from @parameters p where isnull(p.LengthCheck, -15) <> 0 ) begin return end delete  @parameters insert into @parameters (ParameterName, ParameterValue, isCrypted, isHidden, LengthCheck) select ParameterName6, ParameterValue, isCrypted, isHidden, 0 as LengthCheck from dbo.QBM_FCVJobParameterToList_cl (@paramin) EndLabel: return end 7