Back to OIM Explorer

dbo.ATT_FTAttCasesForBaseObject

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

  • No direct source references extracted.

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.ATT_FTAttCasesForBaseObject(2  @ObjectKeyRelated varchar(138)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7SELECT y.UID_AttestationCase8FROM(9SELECT10  ac.UID_AttestationCase, ac.ObjectKey1, ac.ObjectKeyBase, ac.ObjectKey2, ac.ObjectKey311FROM dbo.AttestationCase ac) AS x unpivot(ObjectKeyRelated FOR spalte IN(ObjectKey1, ObjectKeyBase, ObjectKey2,12ObjectKey3)) AS y13WHERE14  y.ObjectKeyRelated = @ObjectKeyRelated)
Open raw exported source
SQL ยท Raw4 lines
1create function dbo.ATT_FTAttCasesForBaseObject( @ObjectKeyRelated varchar(138) ) returns table with schemabinding as return ( select y.UID_AttestationCase2 from ( select ac.UID_AttestationCase, ac.ObjectKey1, ac.ObjectKeyBase , ac.ObjectKey2 , ac.ObjectKey3 from dbo.AttestationCase ac ) as x unpivot (ObjectKeyRelated3 for spalte in (ObjectKey1,ObjectKeyBase , ObjectKey2, ObjectKey3)) as y where y.ObjectKeyRelated = @ObjectKeyRelated ) 4