dbo.QBM_FTHexPattern

SQL_INLINE_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:14:10.677 · modified 2026-04-14T23:14:10.677 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@CountDigits`	int	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

Source excerpt

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

Open full formatted source

1create function dbo.QBM_FTHexPattern(@CountDigits int) returns table with SCHEMABINDING as return( with einer(zeichen) as ( select a.z from ( values ('0'
2) , ('1') , ('2') , ('3') , ('4') , ('5') , ('6') , ('7') , ('8') , ('9') , ('A') , ('B') , ('C') , ('D') , ('E') , ('F') , ('[^0-F]')  ) as a (z) ) select
3 concat(e1.zeichen , e2.zeichen, e3.zeichen, e4.zeichen, e5.zeichen  , '%') as HexPattern from einer e1 left outer join einer e2 on @CountDigits > 1  left
4 outer join einer e3 on @CountDigits > 2  left outer join einer e4 on @CountDigits > 3  left outer join einer e5 on @CountDigits > 4    )  
5

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:14:10.677

None extracted.

Summary: reads/joins einer

Declared parameters

Parameter	Type	Direction
`@CountDigits`	`int`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

einer

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @CountDigits

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.ADS_PAfterMigrationJobCreate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ATT_PAttestationCaseCreate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ATT_PHelperAttestationPolicy	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_PAfterMigrationJobCreate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZJobHistoryShrink	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZProcessShrink	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZProgressViewShrink	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZWatchShrink	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PAfterMigrationJobCreate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_PAfterMigrationJobCreate	source text reference	creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling
dbo.ATT_PAttestationCaseCreate	source text reference	uses session context values, has TRY/CATCH error handling
dbo.ATT_PHelperAttestationPolicy	source text reference	uses session context values, has TRY/CATCH error handling
dbo.LDP_PAfterMigrationJobCreate	source text reference	creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling
dbo.QBM_ZJobHistoryShrink	source text reference	inserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_ZProcessShrink	source text reference	inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_ZProgressViewShrink	source text reference	inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_ZWatchShrink	source text reference	inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_PAfterMigrationJobCreate	source text reference	creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling