Back to OIM Explorer

dbo.ADS_FGIGroupInGroupValid

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL21 lines
1CREATE FUNCTION dbo.ADS_FGIGroupInGroupValid(2  @UID_ADSDomainGroup varchar(38),3  @uid_ADSGroupGroup varchar(38),4  @UID_ADSDomainMember varchar(38),5  @uid_ADSGroupMember varchar(38)6) RETURNS int7AS8BEGIN9  DECLARE @erg int = 010  IF EXISTS(11    SELECT TOP 1 112    FROM ADS_VGroupMemberValid_Group v13    WHERE14      v.UID_ADSDomainContainer = @UID_ADSDomainGroup AND v.UID_ADSDomainMember = @UID_ADSDomainMember AND v.UID_ADSGroupContainer = @uid_ADSGroupGroup AND15  v.UID_ADSGroupMember = @uid_ADSGroupMember)16  BEGIN17    SELECT @erg = 118  END19  endLabel:20  RETURN(@erg)21END
Open raw exported source
SQL ยท Raw5 lines
1    create   function dbo.ADS_FGIGroupInGroupValid ( @UID_ADSDomainGroup varchar(38) , @uid_ADSGroupGroup varchar(38) , @UID_ADSDomainMember varchar2(38)  , @uid_ADSGroupMember varchar(38)  ) returns int as begin declare @erg int = 0 if exists (select top 1 1 from ADS_VGroupMemberValid_Group v where3 v.UID_ADSDomainContainer = @UID_ADSDomainGroup and v.UID_ADSDomainMember = @UID_ADSDomainMember and v.UID_ADSGroupContainer = @uid_ADSGroupGroup and v.UID_ADSGroupMember4 = @uid_ADSGroupMember ) begin select @erg = 1 end endLabel: return(@erg) end 5