dbo.QBM_FSQCEFParmSelect

SQL_SCALAR_FUNCTION

Created 2025-12-15T18:07:52.840 · modified 2026-04-14T23:20:32.237 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	nvarchar	yes
`@Tablename`	varchar	no
`@ParameterDef`	varchar	no
`@Alias`	varchar	no
`@JoinAlias`	varchar	no

Referenced objects

Schema	Object	Class
	DialogColumn	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	QBM_VQBMRelation	OBJECT_OR_COLUMN
dbo	QBM_FSQCEFTableDisplay	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_FSQCEFParmSelect(@Tablename varchar(30) , @ParameterDef varchar(64) , @Alias varchar(16) , @JoinAlias varchar(16)  
2) returns nvarchar(max) as begin declare @Erg nvarchar(max) = '' declare @ColumnName varchar(30) = null declare @SchemaDatatype varchar(64) = null declare
3 @isForeignKey bit = 0 declare @IsPKMember bit = 0 declare @Parenttable varchar(30) declare @ParentColumn varchar(30) select top 1 @ColumnName = c.ColumnName
4 , @SchemaDatatype = c.SchemaDataType , @isForeignKey = c.IsForeignKey , @IsPKMember = c.IsPKMember from DialogColumn c join DialogTable t on c.UID_DialogTable
5 = t.UID_DialogTable where c.ColumnName = replace(replace(replace(@ParameterDef , 'and t.Tablename = @Tablename if @ParameterDef
6 like '%[[]O]%' begin select @Alias = 'old' end if trim(@ParameterDef) like '$Script(%)$%' begin select @erg = concat('''', @ParameterDef, '''') goto EndLabel
7 end select @Erg = case isnull(@SchemaDatatype, '') when 'int' then concat('dbo.QBM_FCVIntToString(' , @Alias , '.' , @columnname , ')' ) when 'bigint'
8 then concat('dbo.QBM_FCVBigIntToString(' , @Alias , '.' , @columnname , ')') when 'datetime' then concat('dbo.QBM_FCVDateTimeToString(' , @Alias , '.'
9 , @columnname , ')') when 'Float' then concat('dbo.QBM_FCVFloatToString(' , @Alias , '.' , @columnname , ')' ) when 'Bit' then concat('dbo.QBM_FCVBitToString('
10 , @Alias , '.' , @columnname , ')' ) when 'varbinary' then concat('dbo.QBM_FCVBinaryToString(' , @Alias , '.' , @columnname , ', 0)' ) else case when 
11@SchemaDatatype is null and isnull(@ParameterDef, '') > ' ' then '''<temporarily ParameterDefinition>''' when @SchemaDatatype is null then ' '''' ' else
12 concat ( 'left (isnull( ', @Alias , '.' , @columnname , ', ''''), 1024)' ) end end if @isForeignKey = 1 begin select top 1 @Parenttable = isnull(rb.ParentTable
13, ra.ParentTable) , @ParentColumn = isnull(rb.ParentColumn, ra.ParentColumn) from QBM_VQBMRelation ra left outer join QBM_VQBMRelation rb on ra.UID_QBMRelationBase
14 = rb.UID_QBMRelation where ra.ChildTable = @Tablename and ra.ChildColumn = @ColumnName select @Erg = dbo.QBM_FSQCEFTableDisplay(@ParentTable , @JoinAlias
15 ) goto endLabel end if @IsPKMember = 1 begin select @erg = dbo.QBM_FSQCEFTableDisplay(@Tablename , @Alias ) end endLabel: return (@Erg) end 
16

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

None extracted.

Summary: reads/joins DialogColumn, DialogTable, QBM_VQBMRelation

Declared parameters

Parameter	Type	Direction
	`nvarchar`	OUTPUT
`@Tablename`	`varchar(30)`	input
`@ParameterDef`	`varchar(64)`	input
`@Alias`	`varchar(16)`	input
`@JoinAlias`	`varchar(16)`	input

DML targets

None extracted.

Called routines

None extracted.

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: @Tablename @ParameterDef @Alias @JoinAlias @Erg @ColumnName @SchemaDatatype @isForeignKey @IsPKMember @Parenttable @ParentColumn @erg @columnname @ParentTable

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