dbo.QBM_FSQCEFJoin

SQL_SCALAR_FUNCTION

Created 2025-12-15T18:07:52.867 · modified 2026-04-14T23:20:32.247 · 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	Column/minor	Class
	DialogColumn		OBJECT_OR_COLUMN
	DialogTable		OBJECT_OR_COLUMN
	QBM_VQBMRelation		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_FSQCEFJoin(@Tablename varchar(30) , @ParameterDef varchar(64) , @Alias varchar(16) , @JoinAlias varchar(16)  ) returns
2 nvarchar(max) as begin declare @JoinCondition nvarchar(max) = '' declare @Parenttable varchar(30) declare @ParentColumn varchar(30) declare @isForeignKey
3 bit = 0 declare @ColumnName varchar(30) = null declare @SchemaDatatype varchar(64) = null select top 1 @ColumnName = c.ColumnName , @SchemaDatatype = 
4c.SchemaDataType , @isForeignKey = c.IsForeignKey from DialogColumn c join DialogTable t on c.UID_DialogTable = t.UID_DialogTable where c.ColumnName = 
5replace(replace(replace(@ParameterDef , 'and t.Tablename = @Tablename if @ParameterDef like '%[[]O]%' begin select @Alias
6 = 'old' end if @isForeignKey = 1 begin select top 1 @Parenttable = isnull(rb.ParentTable, ra.ParentTable) , @ParentColumn = isnull(rb.ParentColumn, ra.ParentColumn
7) , @ColumnName = ISNULL(rb.childColumn, ra.ChildColumn) from QBM_VQBMRelation ra left outer join QBM_VQBMRelation rb on ra.UID_QBMRelationBase = rb.UID_QBMRelation
8 where ra.ChildTable = @Tablename and ra.ChildColumn = @ColumnName select @JoinCondition = concat(' left outer join ' , @Parenttable , ' ' , @JoinAlias
9 , ' on ' , @Alias , '.' , @ColumnName , ' = ' , @JoinAlias, '.' , @ParentColumn , char(13), char(10) ) end return (@JoinCondition) end 
10

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

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 @JoinCondition @Parenttable @ParentColumn @isForeignKey @ColumnName @SchemaDatatype

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