dbo.DPR_FSQTriggerWatchMemberShip

SQL_SCALAR_FUNCTION

Created 2025-06-27T18:01:03.120 · modified 2026-04-14T23:20:35.580 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	nvarchar	yes
`@ChildTable`	varchar	no
`@Operation`	varchar	no

Referenced objects

Schema	Object	Class
	DialogColumn	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	DialogValidDynamicRef	OBJECT_OR_COLUMN
	DPRNameSpaceHasDialogTable	OBJECT_OR_COLUMN
	QBM_VQBMRelation	OBJECT_OR_COLUMN
	QBM_YCursorBuffer	TYPE
dbo	QBM_FCVBinaryToString	OBJECT_OR_COLUMN
dbo	QBM_FCVStringToIndent	OBJECT_OR_COLUMN
dbo	QBM_FGIBitPatternXMarkedForDel	OBJECT_OR_COLUMN
dbo	QBM_FGIColumnExists	OBJECT_OR_COLUMN
dbo	QBM_FGITableName	OBJECT_OR_COLUMN
dbo	QBM_FSQTableJoin	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.DPR_FSQTriggerWatchMemberShip(@ChildTable varchar(30) , @Operation varchar(16) ) returns nvarchar(max) as begin declare 
2@IsXOriginHandling bit = 0 declare @IsXIsInEffectHandling bit = 0 declare @IsXMarkedForDeletionHandling bit = 0 declare @Erg nvarchar(max) = '' declare
3 @ErgSim nvarchar(max) = '' declare @ContainerTable varchar(30) declare @ContainerColumn varchar(30) declare @ChildConnectContainer varchar(30) declare
4 @MemberTable varchar(30) declare @MemberColumn varchar(30) declare @ChildConnectMember varchar(30) declare @UID_ContainerTable varchar(38) declare @UID_DPRNameSpace
5 varchar(38) declare @ContainerObjectKey nvarchar(1000) declare @MemberObjectKey nvarchar(1000)  declare @OpAddDel nvarchar(max) declare @OpSynonym varchar
6(16) = 'deleted' declare @joinDeletedReal nvarchar(max) = '--' declare @whereClauseSoFar nvarchar(max) = '1=1' declare @whereClause nvarchar(max) declare
7 @StringPatternFullsync nvarchar(100) declare @StringPatternOutStanding nvarchar(100) declare @ElementNummer int = 0 declare @DebugSwitch int = 0 declare
8 @DebugMessage nvarchar(max) declare @DebugOnly nvarchar(16) = '--Debug ' declare @crlf nvarchar(20) = nchar(13) + nchar(10) declare @AdditionalWhereClause
9 nvarchar(max) declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @Pattern1 nvarchar(max) ='
10insert into DPRMemberShipAction	(
11	 UID_DPRMemberShipAction
12	, ObjectKeyMN  
13	, Operation 
14	, ObjectKeyBase 
15	, ObjectKeyMember 
16	, UID_DPRNameSpace
17	, OperationDate
18	, XObjectKey
19			)
20'
21 declare @Pattern2 nvarchar(max) ='
22select 	 y.UID_DPRMemberShipAction
23	, y.ObjectKeyMN  
24	, y.Operation 
25	, y.ObjectKeyBase 
26	, y.ObjectKeyMember 
27	, y.UID_DPRNameSpace
28	, y.OperationDate
29	, dbo.QBM_FCVElementToObjectKey1(''DPRMemberShipAction'', ''UID_DPRMemberShipAction'', y.UID_DPRMemberShipAction)
30from (
31	 select 
32		i.XObjectKey as ObjectKeyMN
33		, @OpAddDel as Operation  
34		, @ContainerObjectKey as ObjectKeyBase
35		, @MemberObjectKey as ObjectKeyMember
36		, ''@UID_DPRNameSpace'' as UID_DPRNameSpace
37		, @TrackingDate as OperationDate
38		, newid() as UID_DPRMemberShipAction
39		from @OPSynonym i -- @ChildTable
40				@joinDeletedReal@
41		join @Containertable ContainerTable on i.@ChildConnectContainer = ContainerTable.@ContainerColumn
42						join @MemberTable MemberTable on i.@ChildConnectMember = MemberTable.@MemberColumn
43						@v33365
44		@WhereClause
45	) as y
46'
47 declare @pattern2_33365 nvarchar(max) declare @Pattern3 nvarchar(max) = '
48 
49	if @IsSimulationMode = 1
50	 begin
51
52		delete @SimulationModeBuffer
53
54		insert into @SimulationModeBuffer (operation, BaseObjectType, ColumnName, Objectkey, OldValue) 
55		select ''I'', ''DPRMemberShipAction'', ''UID_DPRMemberShipAction'', m.XObjectKey , '''' 
56		from DPRMemberShipAction m
57			where m.OperationDate = @TrackingDate
58		union all
59		select ''I'', ''DPRMemberShipAction'', ''ObjectKeyMN'', m.XObjectKey , '''' 
60		from DPRMemberShipAction m
61			where m.OperationDate = @TrackingDate
62		union all
63		select ''I'', ''DPRMemberShipAction'', ''Operation'', m.XObjectKey , '''' 
64		from DPRMemberShipAction m
65			where m.OperationDate = @TrackingDate
66		union all
67		select ''I'', ''DPRMemberShipAction'', ''ObjectKeyBase'', m.XObjectKey , '''' 
68		from DPRMemberShipAction m
69			where m.OperationDate = @TrackingDate
70		union all
71		select ''I'', ''DPRMemberShipAction'', ''ObjectKeyMember'', m.XObjectKey , '''' 
72		from DPRMemberShipAction m
73			where m.OperationDate = @TrackingDate
74		union all
75		select ''I'', ''DPRMemberShipAction'', ''UID_DPRNameSpace'', m.XObjectKey , '''' 
76		from DPRMemberShipAction m
77			where m.OperationDate = @TrackingDate
78		union all
79		select ''I'', ''DPRMemberShipAction'', ''OperationDate'', m.XObjectKey , '''' 
80		from DPRMemberShipAction m

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:35.580

uses session context values

Summary: calls QBM_PFESimulationFill; writes INSERT DPRMemberShipAction, INSERT into, DELETE nix, DELETE DPRMemberShipAction; reads/joins DPRMemberShipAction, DialogTable, QBM_VQBMRelation, DPRNameSpaceHasDialogTable, DialogColumn…

Declared parameters

Parameter	Type	Direction
	`nvarchar`	OUTPUT
`@ChildTable`	`varchar(30)`	input
`@Operation`	`varchar(16)`	input

DML targets

INSERT DPRMemberShipAction INSERT into DELETE nix DELETE DPRMemberShipAction

Called routines

QBM_PFESimulationFill

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @ChildTable @Operation @IsXOriginHandling @IsXIsInEffectHandling @IsXMarkedForDeletionHandling @Erg @ErgSim @ContainerTable @ContainerColumn @ChildConnectContainer @MemberTable @MemberColumn @ChildConnectMember @UID_ContainerTable @UID_DPRNameSpace @ContainerObjectKey @MemberObjectKey @OpAddDel @OpSynonym @joinDeletedReal @StringPatternFullsync @StringPatternOutStanding @ElementNummer @DebugSwitch @DebugMessage @DebugOnly @ElementBuffer @ElementCount @ElementIndex @Pattern1 @Pattern2 @TrackingDate @OPSynonym @Containertable @v33365 @WhereClause @pattern2_33365 @Pattern3 @IsSimulationMode @SimulationModeBuffer

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.DPR_PTriggerCreateMembership	SQL expression dependency	dbo · OBJECT_OR_COLUMN