Back to OIM Explorer

dbo.ADS_FTGroupMembersValid_G

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 729 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.ADS_FTGroupMembersValid_G_OC source text reference

References

Referenced By

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.ADS_FTGroupMembersValid_G(2  @UID_ADSGroup varchar(38)3) RETURNS TABLE4AS5RETURN(6SELECT7  @UID_ADSGroup AS UID_ADSGroup,8  v.UID_ADSDomainMember AS UID_ADSDomainMember,9  v.ObjectKeyMember AS ObjectKeyMember10FROM dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSAccount') v11UNION all12SELECT13  @UID_ADSGroup,14  v.UID_ADSDomainMember,15  v.ObjectKeyMember16FROM dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSContact') v17UNION all18SELECT19  @UID_ADSGroup,20  v.UID_ADSDomainMember,21  v.ObjectKeyMember22FROM dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSMachine') v23UNION all24SELECT25  @UID_ADSGroup,26  v.UID_ADSDomainMember,27  v.ObjectKeyMember28FROM dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSGroup') v)
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.ADS_FTGroupMembersValid_G (@UID_ADSGroup varchar(38) )  returns table as return ( select @UID_ADSGroup as UID_ADSGroup, v.UID_ADSDomainMember2 as UID_ADSDomainMember , v.ObjectKeyMember as ObjectKeyMember from dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSAccount') v union all select @UID_ADSGroup3, v.UID_ADSDomainMember, v.ObjectKeyMember from dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSContact') v union all select @UID_ADSGroup, v.UID_ADSDomainMember4, v.ObjectKeyMember from dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSMachine') v union all select @UID_ADSGroup, v.UID_ADSDomainMember, v.ObjectKeyMember5 from dbo.ADS_FTGroupMembersValid_G_OC(@UID_ADSGroup, 'ADSGroup') v ) 6