Back to OIM Explorer

dbo.QBM_FSQModuleLower

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL24 lines
1CREATE FUNCTION dbo.QBM_FSQModuleLower(2  @ModuleName varchar(3)3) RETURNS nvarchar(max4)5AS6BEGIN7  RETURN(8  SELECT TOP 1 CASE9  WHEN x.kette > ' ' THEN10  CONCAT('(', x.kette, ')')11  ELSE '(''XXXX'')'12  END13  FROM(14  SELECT15    String_agg(convert(nvarchar(max), CONCAT('''', p.Element, '''')), N ',') AS kette16  FROM(17  SELECT18    DISTINCT19    LEFT(co.UID_ModulePredecessor, 4) AS Element20  FROM dbo.QBMModuleDependCollection co21    WITH(readpast)22  WHERE23  LEFT(co.UID_ModuleFollower, 3) = @ModuleName) AS p) AS x)24END
Open raw exported source
SQL ยท Raw5 lines
1   create   function dbo.QBM_FSQModuleLower (@ModuleName varchar(3)) returns nvarchar(max)  as begin return( select top 1 case when x.kette > ' '2 then concat('(', x.kette, ')') else '(''XXXX'')' end from ( select String_agg( convert(nvarchar(max), concat('''', p.Element, '''') )  , N',' )  as kette3 from ( select distinct left(co.UID_ModulePredecessor, 4) as Element from dbo.QBMModuleDependCollection co with (readpast) where left(co.UID_ModuleFollower4, 3) = @ModuleName ) as p ) as x ) end 5