Back to OIM Explorer

dbo.QER_FGIAERoleValidForGroup

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL41 lines
1CREATE FUNCTION dbo.QER_FGIAERoleValidForGroup(2  @uid_AERole varchar(38),3  @groupname nvarchar(64)4) RETURNS int5AS6BEGIN7  DECLARE @erg int8  DECLARE @uid_AERole_intern varchar(38)9  DECLARE @UID_ParentAERole varchar(38)10  DECLARE @groupname_ist nvarchar(64)11  SELECT @uid_AERole_intern = @uid_AERole12  SELECT @erg = 0 marke:13  SELECT14    TOP 1 @groupname_ist = g.GroupName,15    @UID_ParentAERole = ae.UID_ParentAERole16  FROM AERole ae17  LEFT18  OUTER19  JOIN DialogGroup g20    ON ae.UID_DialogGroup = g.UID_DialogGroup21  WHERE22    ae.UID_AERole = @uid_AERole_intern23  IF @groupname_ist > ' '24  BEGIN25    IF @groupname_ist = @Groupname26    BEGIN27      SELECT @erg = 128      GOTO ende29    END30  END31  ELSE32  BEGIN33    IF @UID_ParentAERole > ' '34    BEGIN35      SELECT @uid_AERole_intern = @UID_ParentAERole36      GOTO marke37    END38  END39  ende:40  RETURN(@erg)41END
Open raw exported source
SQL ยท Raw6 lines
1   create   function dbo.QER_FGIAERoleValidForGroup ( @uid_AERole varchar(38), @groupname nvarchar(64) ) returns int as begin declare @erg int declare2 @uid_AERole_intern varchar(38) declare @UID_ParentAERole varchar(38) declare @groupname_ist nvarchar(64) select @uid_AERole_intern = @uid_AERole select3 @erg = 0 marke: select top 1 @groupname_ist = g.GroupName, @UID_ParentAERole = ae.UID_ParentAERole from AERole ae left outer join DialogGroup g on ae.UID_DialogGroup4 = g.UID_DialogGroup where ae.UID_AERole = @uid_AERole_intern if @groupname_ist > ' ' begin if @groupname_ist = @Groupname begin select @erg = 1 goto ende5 end end else begin  if @UID_ParentAERole > ' ' begin  select @uid_AERole_intern = @UID_ParentAERole goto marke end end ende: return(@erg) end 6