Back to OIM Explorer

dbo.ADS_FTGroupMembersValid_G_OC

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL68 lines
1CREATE FUNCTION dbo.ADS_FTGroupMembersValid_G_OC(2  @UID_ADSGroup varchar(38),3  @TableName varchar(30)4) RETURNS @erg TABLE(UID_ADSGroup varchar(38) collate database_default,5UID_ADSDomainMember varchar(38) collate database_default,6ObjectKeyMember varchar(138) collate database_default7)8AS9BEGIN10  IF @TableName = 'ADSAccount'11  BEGIN12    INSERT INTO @erg(UID_ADSGroup,13    UID_ADSDomainMember,14    ObjectKeyMember)15    SELECT16      @UID_ADSGroup,17      v.UID_ADSDomainMember,18      v.XObjectKeyMember19    FROM ADS_VGroupMemberValid_Account v20    WHERE21      v.UID_ADSGroupContainer = @UID_ADSGroup22    GOTO Endlabel23  END24  IF @TableName = 'ADSContact'25  BEGIN26    INSERT INTO @erg(UID_ADSGroup,27    UID_ADSDomainMember,28    ObjectKeyMember)29    SELECT30      @UID_ADSGroup,31      v.UID_ADSDomainMember,32      v.XObjectKeyMember33    FROM ADS_VGroupMemberValid_Contact v34    WHERE35      v.UID_ADSGroupContainer = @UID_ADSGroup36    GOTO Endlabel37  END38  IF @TableName = 'ADSMachine'39  BEGIN40    INSERT INTO @erg(UID_ADSGroup,41    UID_ADSDomainMember,42    ObjectKeyMember)43    SELECT44      @UID_ADSGroup,45      v.UID_ADSDomainMember,46      v.XObjectKeyMember47    FROM ADS_VGroupMemberValid_Machine v48    WHERE49      v.UID_ADSGroupContainer = @UID_ADSGroup50    GOTO Endlabel51  END52  IF @TableName = 'ADSGroup'53  BEGIN54    INSERT INTO @erg(UID_ADSGroup,55    UID_ADSDomainMember,56    ObjectKeyMember)57    SELECT58      @UID_ADSGroup,59      v.UID_ADSDomainMember,60      v.XObjectKeyMember61    FROM ADS_VGroupMemberValid_Group v62    WHERE63      v.UID_ADSGroupContainer = @UID_ADSGroup64    GOTO Endlabel65  END66  endLabel:67  RETURN68END
Open raw exported source
SQL ยท Raw11 lines
1create function dbo.ADS_FTGroupMembersValid_G_OC (@UID_ADSGroup varchar(38) , @TableName varchar(30)  ) returns @erg table (UID_ADSGroup varchar(38) collate2 database_default , UID_ADSDomainMember varchar(38) collate database_default , ObjectKeyMember varchar(138) collate database_default ) as begin if @TableName3 = 'ADSAccount' begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select @UID_ADSGroup, v.UID_ADSDomainMember, v.XObjectKeyMember4 from ADS_VGroupMemberValid_Account v where v.UID_ADSGroupContainer = @UID_ADSGroup goto Endlabel end if @TableName = 'ADSContact' begin insert into @erg5(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select @UID_ADSGroup, v.UID_ADSDomainMember, v.XObjectKeyMember from ADS_VGroupMemberValid_Contact6 v where v.UID_ADSGroupContainer = @UID_ADSGroup goto Endlabel end if @TableName = 'ADSMachine' begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember7, ObjectKeyMember) select @UID_ADSGroup, v.UID_ADSDomainMember, v.XObjectKeyMember from ADS_VGroupMemberValid_Machine v where v.UID_ADSGroupContainer =8 @UID_ADSGroup goto Endlabel end if @TableName = 'ADSGroup' begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select @UID_ADSGroup9, v.UID_ADSDomainMember, v.XObjectKeyMember from ADS_VGroupMemberValid_Group v where v.UID_ADSGroupContainer = @UID_ADSGroup goto Endlabel end endLabel:10 return end 11