dbo.QBM_FSQWatchRevision

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:36.997 · modified 2026-04-14T23:20:27.037 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	nvarchar	yes
`@tablename`	varchar	no
`@operation`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
	QBM_VTablesForRevision		OBJECT_OR_COLUMN
dbo	QBM_FGIConfigparmValue		OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1  create   function dbo.QBM_FSQWatchRevision (@tablename varchar(30) , @operation varchar(16) ) returns nvarchar(max) as begin declare @erg nvarchar
2(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 from
4 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_YParameterList
7insert 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 @TableNamesForRevision
12'
13 )  goto endLabel end    endLabel: return(@erg) end 
14

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:27.037

None extracted.

Summary: calls QBM_PTableRevisionSetMulti; writes INSERT into; reads/joins QBM_VTablesForRevision; uses config Common\TableRevision

Declared parameters

Parameter	Type	Direction
	`nvarchar`	OUTPUT
`@tablename`	`varchar(30)`	input
`@operation`	`varchar(16)`	input

DML targets

INSERT into

Called routines

QBM_PTableRevisionSetMulti

Read/join references

QBM_VTablesForRevision

SQL dependency metadata

Config/session

Config: Common\TableRevision

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @tablename @operation @erg @tabletype @OpSynomym @Operation @revisionTable @TableNamesForRevision

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing object	Relation	Evidence
dbo.QBM_PTriggerWatchCreate	SQL expression dependency	dbo · OBJECT_OR_COLUMN