dbo.QBM_FSQCVColumnToBuffer

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
	nvarchar	yes
`@TableName`	varchar	no
`@columnname`	varchar	no
`@TableSynonym`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
dbo	QBM_FGIColumnDataLen		OBJECT_OR_COLUMN
dbo	QBM_FGIColumnDataType		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_FSQCVColumnToBuffer (@TableName varchar(30) , @columnname varchar(30) , @TableSynonym varchar(64) ) returns nvarchar
2(max) as begin declare @erg nvarchar(max) declare @datatype nvarchar(64) declare @DataMaxLen int select @datatype = dbo.QBM_FGIColumnDataType(@TableName
3 , @columnname) select @DataMaxLen = dbo.QBM_FGIColumnDataLen(@TableName , @columnname) if @datatype = 'int' begin select @erg = concat('dbo.QBM_FCVIntToString('
4 , @TableSynonym , '.' , @columnname , '), 0, null') goto ende end  if @datatype = 'bigint' begin select @erg = concat('dbo.QBM_FCVBigIntToString(' , @TableSynonym
5 , '.' , @columnname , '), 0, null') goto ende end if @datatype = 'datetime' begin select @erg = concat('dbo.QBM_FCVDateTimeToString(' , @TableSynonym 
6, '.' , @columnname , '), 0, null') goto ende end if @datatype = 'Float' begin select @erg = concat('dbo.QBM_FCVFloatToString(' , @TableSynonym , '.' ,
7 @columnname , '), 0, null') goto ende end if @datatype = 'Bit' begin select @erg = concat('dbo.QBM_FCVBitToString(' , @TableSynonym , '.' , @columnname
8 , '), 0, null') goto ende end  if @datatype = 'timestamp' begin select @erg = concat('dbo.QBM_FCVBinaryToString(' , @TableSynonym , '.' , @columnname 
9, ', 0), 0, null') goto ende end   if @datatype = 'varbinary' begin if @DataMaxLen <= 300  begin select @erg = concat('dbo.QBM_FCVBinaryToString(' , @TableSynonym
10 , '.' , @columnname , ', 1), 0, null') end else  begin select @erg = concat('
11left(dbo.QBM_FCVBinaryToString(' , @TableSynonym , '.' , @columnname , 
12', 1), 400)
13			, 	case 
14					when DATALENGTH(' , @TableSynonym , '.' , @columnname , ') >  300 then 1
15					else 0
16				end
17					, 	case 
18							when DATALENGTH('
19 , @TableSynonym , '.' , @columnname , ') >  300 then dbo.QBM_FCVBinaryToString(' , @TableSynonym , '.' , @columnname , ', 1)
20							else null
21						end
22					'
23 ) end goto ende end if @datatype in( 'char' , 'nchar', 'varchar', 'nvarchar') begin if @DataMaxLen <= 400 begin select @erg = concat('' , @TableSynonym
24 , '.' , @columnname , ', 0, null') end else  begin select @erg = concat('
25case 
26	when ' , @TableSynonym , '.' , @columnname , ' > '' '' then left(' 
27, @TableSynonym , '.' , @columnname , ', 400)
28	else null
29  end, 						
30		case 
31			when len(' , @TableSynonym , '.' , @columnname , ') >  400 then 1
32			else 0
33		end
34			, 	case 
35					when len('
36 , @TableSynonym , '.' , @columnname , ') >  400 then ' , @TableSynonym , '.' , @columnname , '
37					else null
38				end
39			' ) end goto ende end  select
40 @erg = ' message  this_must_be_an_invalid_datatype' ende: return(@erg) end 
41

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

None extracted.

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

Declared parameters

Parameter	Type	Direction
	`nvarchar`	OUTPUT
`@TableName`	`varchar(30)`	input
`@columnname`	`varchar(30)`	input
`@TableSynonym`	`varchar(64)`	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: @TableName @columnname @TableSynonym @erg @datatype @DataMaxLen

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_FSQBufferConfigSaveOrigin	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FSQTriggerWatchColumn	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferT_FillColumn	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferT_FillColumn_CCC	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcessUpdate	SQL expression dependency	dbo · OBJECT_OR_COLUMN