Back to OIM Explorer

dbo.QBM_FCVJobParameterToString

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 710 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_FCVStringToJobParameter source text reference

References

Referenced By

Complete Source

SQL27 lines
1CREATE FUNCTION dbo.QBM_FCVJobParameterToString(2  @uid_tree varchar(38)3) RETURNS nvarchar(max4)5AS6BEGIN7  RETURN(8  SELECT9    CONCAT('~', string_agg(convert(nvarchar(max), CONCAT(dbo.QBM_FCVStringToJobParameter(bu.ParameterName),10    dbo.QBM_FCVStringToJobParameter(bu.ParameterValue), dbo.QBM_FCVStringToJobParameter(CASE11    WHEN bu.IsHidden = 1 AND bu.IsCrypted = 1 THEN12    'HIDDEN|CRYPTED'13    WHEN bu.IsHidden = 1 THEN14    'HIDDEN'15    WHEN bu.IsCrypted = 1 THEN16    'CRYPTED'17  ELSE ''18  END))), N ''))19  FROM(20  SELECT21    pc.ParameterName, pc.ParameterValue, isnull(pc.IsCrypted, 0) AS IsCrypted, isnull(pc.IsHidden,22    0) AS IsHidden23  FROM JobTreeParamColl pc24    WITH(readpast)25  WHERE26    pc.UID_Tree = @uid_tree) AS bu)27END
Open raw exported source
SQL ยท Raw6 lines
1  create   function dbo.QBM_FCVJobParameterToString (@uid_tree varchar(38) ) returns nvarchar(max) as begin return( select concat( '~' , string_agg2 (convert(nvarchar(max), concat( dbo.QBM_FCVStringToJobParameter(bu.ParameterName) , dbo.QBM_FCVStringToJobParameter(bu.ParameterValue)  , dbo.QBM_FCVStringToJobParameter3( case when bu.IsHidden = 1 and bu.IsCrypted = 1 then 'HIDDEN|CRYPTED' when bu.IsHidden = 1 then 'HIDDEN' when bu.IsCrypted = 1 then 'CRYPTED' else '' 4end ) )  )  , N''  )  )  from ( select pc.ParameterName, pc.ParameterValue, isnull(pc.IsCrypted,0) as IsCrypted, isnull(pc.IsHidden,0) as IsHidden from5 JobTreeParamColl pc with (readpast) where pc.UID_Tree = @uid_tree ) as bu ) end 6