dbo.QBM_FGIGuidIsValid

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@Guid`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
dbo	QBM_FGIDBOwner		OBJECT_OR_COLUMN
dbo	QBM_FGIModuleExists		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_FGIGuidIsValid(@Guid varchar(38) ) returns int as begin declare @erg int = 0   if len(@guid) < 6 begin  return(@erg)
2  end declare @patH nvarchar(256) = '[0-F]'  declare @PatA nvarchar(256) = '[a-z]' declare @patN nvarchar(256) = '[0-Z]'   declare @ModuleOwner varchar
3(3)  declare @ModuleInGuid varchar(3)  if @Guid like  concat(replicate(@path,8) , replicate( concat('-' , replicate(@patH,4)) ,3) , '-' , replicate(@path
4, 12) ) begin select @erg = 1  return(@erg)  end if Len(@Guid) = 38 begin if @Guid like 'XX' + concat(replicate(@path,8) , replicate( concat('-' , replicate
5(@patH,4)) ,3) , '-' , replicate(@path, 12) ) begin select @erg = 1  return(@erg)  end end  if @Guid like concat(@patA , @patN , @PatN , '-%') begin select
6 @erg += 3 end if @Guid like  concat(@patA , @patN , @PatN , '-' , replicate(@path, 32)) begin select @erg += 4 end else begin   if @Guid not like  concat
7(@patA , @patN , @PatN , '-' , @patA , replicate('[0-9,a-z,-]', len(@Guid) - 5)) begin select @erg = 0  return(@erg)  end end select @ModuleInGuid = LEFT
8(@guid, 3) if @ModuleInGuid not in ('ZZZ' , 'XXX' )  begin  if dbo.QBM_FGIModuleExists('HDB') = 0 and dbo.QBM_FGIModuleExists(@ModuleInGuid) = 0 begin 
9select @erg = 0  return(@erg)  end end select top 1 @ModuleOwner = dbo.QBM_FGIDBOwner() if @ModuleInGuid = @ModuleOwner begin select @erg += 8 end endLabel:
10 return(@erg) end 
11

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.523

None extracted.

Summary: No calls/DML/dependency patterns extracted by the current parser.

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@Guid`	`varchar(38)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @Guid @erg @guid @patH @PatA @patN @ModuleOwner @ModuleInGuid @path @patA @PatN

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_FCVGuidToNoTransfer	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FCVGuidToTransfer	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PSessionContextSet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShop_BoardMove	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShop_PRNodesMove	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShop_ShopMove	SQL expression dependency	dbo · OBJECT_OR_COLUMN