dbo.ATT_P600B8EB3A312074D1A10A4A_

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
`@uid_AttestationPolicy`	varchar	no

Referenced objects

Schema	Object	Class
	AttestationCase	OBJECT_OR_COLUMN
	AttestationCaseHasMControl	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_YParameterList	TYPE
dbo	QBM_FGISessionErrorRethrow	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   procedure ATT_P600B8EB3A312074D1A10A4A_(@uid_AttestationPolicy varchar(38) ) as begin declare @ergebnis int = 1 declare @Work QBM_YParameterList
2  SET XACT_ABORT OFF BEGIN TRY insert into @Work (Parameter2 ) select top 2000 c.UID_AttestationCase from AttestationCase c where c.UID_AttestationPolicy
3 = @uid_AttestationPolicy select @ergebnis = @@ROWCOUNT if @ergebnis = 0 begin goto endLabel end  delete AttestationCaseHasMControl from AttestationCaseHasMControl
4 ac with (forceSeek) join @Work w on ac.UID_AttestationCase = w.Parameter2  delete AttestationCase from AttestationCase ac with (forceseek) join @Work 
5w on ac.UID_AttestationCase = w.Parameter2  option (maxdop 1) END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
6() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return (@Ergebnis) end 
7

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

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes INSERT into, DELETE AttestationCaseHasMControl, DELETE AttestationCase; reads/joins AttestationCase, AttestationCaseHasMControl

Declared parameters

Parameter	Type	Direction
`@uid_AttestationPolicy`	`varchar(38)`	input

DML targets

INSERT into DELETE AttestationCaseHasMControl DELETE AttestationCase

Called routines

QBM_PSessionErrorAdd

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: @uid_AttestationPolicy @ergebnis @Work @ROWCOUNT @Rethrow @Ergebnis

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.ATT_ZHelperAttestationPolicy	SQL expression dependency	OBJECT_OR_COLUMN
dbo.ATT_ZHelperAttestationPolicy	source text reference	has TRY/CATCH error handling