Back to OIM Explorer

dbo.QER_FTQERReusePredecessor

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

Complete Source

SQL43 lines
1CREATE FUNCTION dbo.QER_FTQERReusePredecessor(2  @UID_QERReuse varchar(38)3) RETURNS @erg TABLE(UID_QERReusePredecessor varchar(38) collate database_default,4UID_QERReuse varchar(38) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @UID_QERReuseSearch varchar(38)10  DECLARE @UID_QERReusePredecessor varchar(38)11  SELECT @UID_QERReuseSearch = @UID_QERReuse12  INSERT INTO @erg(UID_QERReusePredecessor,13  UID_QERReuse)14  SELECT15    @UID_QERReuse,16    @UID_QERReuse marke:17  SELECT @UID_QERReusePredecessor = NULL18  SELECT TOP 1 @UID_QERReusePredecessor = r.UID_QERReusePredecessor19  FROM dbo.QERReuse r20  WHERE21    r.UID_QERReuse = @UID_QERReuseSearch22  IF @UID_QERReusePredecessor > ' '23  BEGIN24    INSERT INTO @erg(UID_QERReusePredecessor,25    UID_QERReuse)26    SELECT27      @UID_QERReusePredecessor,28      @UID_QERReuse29    WHERE30      NOT EXISTS(31    SELECT TOP 1 132    FROM @erg e33    WHERE34      e.UID_QERReusePredecessor = @UID_QERReusePredecessor)35    IF @@ROWCOUNT > 036    BEGIN37      SELECT @UID_QERReuseSearch = @UID_QERReusePredecessor38      GOTO marke39    END40  END41  EndLabel:42  RETURN43END
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTQERReusePredecessor(@UID_QERReuse varchar(38) ) returns @erg table (UID_QERReusePredecessor varchar(38) collate database_default2 , UID_QERReuse varchar(38) collate database_default ) with schemabinding as begin declare @UID_QERReuseSearch varchar(38) declare @UID_QERReusePredecessor3 varchar(38) select @UID_QERReuseSearch = @UID_QERReuse insert into @erg (UID_QERReusePredecessor, UID_QERReuse) select @UID_QERReuse, @UID_QERReuse marke:4 select @UID_QERReusePredecessor = null select top 1 @UID_QERReusePredecessor = r.UID_QERReusePredecessor from dbo.QERReuse r where r.UID_QERReuse = @UID_QERReuseSearch5 if @UID_QERReusePredecessor > ' ' begin insert into @erg (UID_QERReusePredecessor, UID_QERReuse) select @UID_QERReusePredecessor, @UID_QERReuse where 6Not exists (select top 1 1 from @erg e where e.UID_QERReusePredecessor = @UID_QERReusePredecessor ) if @@ROWCOUNT > 0 begin select @UID_QERReuseSearch 7= @UID_QERReusePredecessor goto marke end end EndLabel: return end 8