Back to OIM Explorer

dbo.DPR_FTSchemaPropertyAccessColl

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

SQL51 lines
1CREATE FUNCTION dbo.DPR_FTSchemaPropertyAccessColl(2) RETURNS @erg TABLE(UID_DPRSchemaPropertySrc varchar(38) collate database_default,3UID_DPRSchemaPropertyTrg varchar(38) collate database_default,4ObjectKeyAccessor varchar(138) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @lauf int10  DECLARE @work dbo.QBM_YParameterList11  INSERT INTO @work(Parameter1,12  Parameter2,13  Parameter3)14  SELECT15    UID_DPRSchemaPropertySrc,16    UID_DPRSchemaPropertyTrg,17    ObjectKeyAccessor18  FROM dbo.DPRSchemaAccess19  WHERE20    AccessType = 'Direct'21  SELECT @lauf = 122  WHILE @lauf > 023  BEGIN24    INSERT INTO @work(Parameter1,25    Parameter2,26    Parameter3)27    SELECT28      DISTINCT e.Parameter1,29      dpr.UID_DPRSchemaPropertyTrg,30      dpr.ObjectKeyAccessor31    FROM @work e32    JOIN dbo.DPRSchemaAccess dpr33      ON e.Parameter2 = dpr.UID_DPRSchemaPropertySrc34    WHERE35      NOT EXISTS(36    SELECT TOP 1 137    FROM @work b38    WHERE39      b.Parameter1 = e.Parameter1 AND b.Parameter2 = dpr.UID_DPRSchemaPropertyTrg) AND dpr.AccessType = 'Direct'40    SELECT @lauf = @@rowcount41  END42  INSERT INTO @erg(UID_DPRSchemaPropertySrc,43  UID_DPRSchemaPropertyTrg,44  ObjectKeyAccessor)45  SELECT46    w.Parameter1,47    w.Parameter2,48    w.Parameter349  FROM @work w50  RETURN51END
Open raw exported source
SQL ยท Raw9 lines
1create function dbo.DPR_FTSchemaPropertyAccessColl () returns @erg table (UID_DPRSchemaPropertySrc varchar(38) collate database_default  , UID_DPRSchemaPropertyTrg2 varchar(38) collate database_default  , ObjectKeyAccessor varchar(138) collate database_default  ) with schemabinding as begin declare @lauf int declare3 @work dbo.QBM_YParameterList insert into @work (Parameter1 , Parameter2 , Parameter3 ) select UID_DPRSchemaPropertySrc, UID_DPRSchemaPropertyTrg, ObjectKeyAccessor4 from dbo.DPRSchemaAccess where AccessType = 'Direct' select @lauf = 1 while @lauf > 0 begin insert into @work (Parameter1  , Parameter2 , Parameter3 )5 select distinct e.Parameter1  , dpr.UID_DPRSchemaPropertyTrg, dpr.ObjectKeyAccessor from @work e join dbo.DPRSchemaAccess dpr on e.Parameter2  = dpr.UID_DPRSchemaPropertySrc6 where Not exists (select top 1 1 from @work b where b.Parameter1  = e.Parameter1  and b.Parameter2  = dpr.UID_DPRSchemaPropertyTrg ) and dpr.AccessType7 = 'Direct' select @lauf = @@rowcount end  insert into @erg (UID_DPRSchemaPropertySrc, UID_DPRSchemaPropertyTrg, ObjectKeyAccessor) select w.Parameter18, w.Parameter2, w.Parameter3 from @work w return end 9