Back to OIM Explorer

dbo.QER_FCVObjectkeyToBaseTree

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 425 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_FCVObjectkeyToElement source text reference

References

Referenced By

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QER_FCVObjectkeyToBaseTree(2  @Objectkey varchar(138)3) RETURNS varchar(384)5AS6BEGIN7  RETURN(CASE8  WHEN dbo.QBM_FCVObjectkeyToElement('ColumnNameBase1', @Objectkey) = 'UID_Org' THEN9  dbo.QBM_FCVObjectkeyToElement('ColumnValue1', @Objectkey)10  WHEN dbo.QBM_FCVObjectkeyToElement('ColumnNameBase2', @Objectkey) = 'UID_Org' THEN11  dbo.QBM_FCVObjectkeyToElement('ColumnValue2', @Objectkey)12  ELSE ''13  END)14END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QER_FCVObjectkeyToBaseTree(@Objectkey varchar(138)) returns varchar(38) as begin return ( case when dbo.QBM_FCVObjectkeyToElement2('ColumnNameBase1', @Objectkey) = 'UID_Org' then dbo.QBM_FCVObjectkeyToElement('ColumnValue1', @Objectkey) when dbo.QBM_FCVObjectkeyToElement('ColumnNameBase2'3, @Objectkey) = 'UID_Org' then dbo.QBM_FCVObjectkeyToElement('ColumnValue2', @Objectkey) else '' end ) end 4