dbo.QBM_FCVXMLMaskedToString

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
	nvarchar	yes
`@in`	nvarchar	no

Referenced objects

Schema	Object	Column/minor	Class
	QBM_VCharacterSpecial		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_FCVXMLMaskedToString (@in nvarchar(max) ) returns nvarchar(max) as begin declare @out nvarchar(max) declare @Zeichen
2 nvarchar(max) declare @len int declare @i int declare @CharacterCoding int declare @CompareLen int declare @isTableFilled bit = 0 declare @umsetz table
3 (NumCoding int , XMLSnippet nvarchar(100) ,compareLen int ) select @len = len(@in) select @i = 1 select @out = N'' while @i <= @len begin select @zeichen
4 = substring(@in, @i, 1) select @CharacterCoding = unicode(@zeichen) if @CharacterCoding <> 38  begin select @out = concat(@out , @Zeichen) select @i =
5 @i+1 continue end  if @isTableFilled = 0 begin insert into @umsetz(NumCoding, XMLSnippet, compareLen) select v.NumCoding, v.XMLSnippet, len(v.XMLSnippet
6) from QBM_VCharacterSpecial v select @isTableFilled = 1 end select top 1 @CharacterCoding = u.NumCoding , @CompareLen = u.compareLen from @umsetz u where
7 substring(@in, @i, 20) like u.XMLSnippet + '%' collate SQL_Latin1_General_CP1_CS_AS  select @out = concat(@out , nchar(@CharacterCoding)) select @i +=
8 @CompareLen end  return(@out) end 
9

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

None extracted.

Summary: writes INSERT into; reads/joins QBM_VCharacterSpecial

Declared parameters

Parameter	Type	Direction
	`nvarchar`	OUTPUT
`@in`	`nvarchar`	input

DML targets

INSERT into

Called routines

None extracted.

Read/join references

QBM_VCharacterSpecial

SQL dependency metadata

QBM_VCharacterSpecial

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @in @out @Zeichen @len @i @CharacterCoding @CompareLen @isTableFilled @umsetz @zeichen

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.

No reverse dependencies extracted.