Back to OIM Explorer

dbo.QBM_FSQWatchRevision

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.093 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.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_PTableRevisionSetMulti source text reference

References

Referenced By

Complete Source

SQL48 lines
1CREATE FUNCTION dbo.QBM_FSQWatchRevision(2  @tablename varchar(30),3  @operation varchar(16)4) RETURNS nvarchar(max5)6AS7BEGIN8  DECLARE @erg nvarchar(max) = ''9  DECLARE @tabletype varchar(16) = NULL10  DECLARE @OpSynomym varchar(16) = CASE @Operation11  WHEN 'Insert' THEN12  'inserted'13  WHEN 'Update' THEN14  'deleted'15  WHEN 'Delete' THEN16  'deleted'17  ELSE 'Fehlerzustand'18  END19  DECLARE @revisionTable varchar(30) = 'QBMTableRevision'20  SELECT TOP 1 @tabletype = r.TableType21  FROM QBM_VTablesForRevision r22  WHERE23    r.IsForCreateWatchTrigger = 1 AND r.TableName = @tablename AND dbo.QBM_FGIConfigparmValue('Common\TableRevision') > ' '24  IF @tabletype IS NULL25  BEGIN26    GOTO endLabel27  END28  IF @tabletype = 'B'29  BEGIN30    SELECT31      @erg = CONCAT('32declare @TableNamesForRevision QBM_YParameterList33insert into @TableNamesForRevision(Parameter1)34select distinct(r.TableName)35	from '36      ,37      @OpSynomym,38      ' x join ',39      @revisionTable,40      ' r with (readpast) on x.XObjectKey like CONCAT(''<Key><T>'', r.TableName, ''</T>%'')41exec QBM_PTableRevisionSetMulti @TableNamesForRevision42'43      )44      GOTO endLabel45  END46  endLabel:47  RETURN(@erg)48END
Open raw exported source
SQL ยท Raw14 lines
1  create   function dbo.QBM_FSQWatchRevision (@tablename varchar(30) , @operation varchar(16) ) returns nvarchar(max) as begin declare @erg nvarchar2(max) = '' declare @tabletype varchar(16) = null declare @OpSynomym varchar(16) = case @Operation when 'Insert' then 'inserted' when 'Update' then 'deleted'3 when 'Delete' then 'deleted' else 'Fehlerzustand' end declare @revisionTable varchar(30) = 'QBMTableRevision' select top 1 @tabletype = r.TableType from4 QBM_VTablesForRevision r where r.IsForCreateWatchTrigger = 1 and r.TableName = @tablename and dbo.QBM_FGIConfigparmValue('Common\TableRevision') > ' '5 if @tabletype is null begin goto endLabel end if @tabletype = 'B' begin select @erg = CONCAT('6declare @TableNamesForRevision QBM_YParameterList7insert into @TableNamesForRevision(Parameter1)8select distinct(r.TableName)9	from '10, @OpSynomym, ' x join ', @revisionTable, ' r with (readpast) on x.XObjectKey like CONCAT(''<Key><T>'', r.TableName, ''</T>%'')11exec QBM_PTableRevisionSetMulti @TableNamesForRevision12'13 )  goto endLabel end    endLabel: return(@erg) end 14