dbo.QBM_FCVElementToObjectKey1

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

NameTypeOutput
varcharyes
@TableNamevarcharno
@ColumnName1Dummyvarcharno
@Value1varcharno

Referenced objects

SchemaObjectColumn/minorClass
dboQBM_FCV0C695385CB1124DCEA40A_OBJECT_OR_COLUMN
dboQBM_FCVStringToXMLMaskedOBJECT_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_FCVElementToObjectKey1 (@TableName varchar(32), @ColumnName1Dummy varchar(32),  @Value1 varchar(256) ) returns varchar
2(138) as begin return(  case when len(@Value1) = 36 then concat('<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName) , '</T><P>' , @value1 , '</P></Key>'
3 ) else  concat( '<Key><T>' , dbo.QBM_FCV0C695385CB1124DCEA40A_(@TableName) , '</T>' , '<P>' ,case when @value1 like '%<%' then rtrim(dbo.QBM_FCVStringToXMLMasked
4(@value1)) else rtrim(@value1) end , '</P>' , '</Key>' )   end  ) end 
5

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

None extracted.

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

Declared parameters

ParameterTypeDirection
varchar(138)OUTPUT
@TableNamevarchar(32)input
@ColumnName1Dummyvarchar(32)input
@Value1varchar(256)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 @ColumnName1Dummy @Value1 @value1

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 objectRelationEvidence
dbo.QBM_FCVObjectKeyMNToParentKeySQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_FGIAdminUnitForPerson_helpSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_PAttestationCaseCreateSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_PAttestationCaseCreate_iSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_PAttestationHelperFillSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_PHelperAttestationPolicySQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_ZAllForPersonInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_ZAttestationResetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.POL_ZQERPolicyFillSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PColumnAddSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PCustomSQLFillSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepareSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepareCheck1SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepareCheck2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDialogColumnInsertSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDiskStorePhysicalSyncSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PDynamicUserForPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PForeignKeyWrongReportSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PJobCreate_SQLDelSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PJobCreate_SQLDel_BSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PJobCreate_SQLDel_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PJobQueueInit_iSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PJobqueueoverViewFillSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PMissingDisplayRightFillSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PMultilanguageFillSQLSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PQBMRelationExpand_OneSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PQBMServerHasJobServiceSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PRelationshipDefineManualSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PTransportHistoryInsertSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PUserDetectByGroupListSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PViewBuildP_internSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_RXDateSubItemUpdateSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_RXDateSubItemUpdateFUSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PBasetreeHasObjectPostProcSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PBasetreeOwnsObjectPost_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PGIQERWorkingMethodSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShop_BoardMoveSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShop_ShopMoveSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopHelperFill_bulkSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopOrderHistoryInsertSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove_bulkSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopPersonHasObjFill_bSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheckSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCreate_bSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PPersonHasObjectPostProcSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PPickedItemInsert_bSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PQEREntitlementSourceDefSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PQERRiskIndexDefineSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PRulerDetect_OXSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PRulerDetect_PXSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_RDynamicGroupTestSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopOrderResetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RPS_ZScheduleStartSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TATTUADSAccountSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TDADSAccountSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TDAdsGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TDADSMachineSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TUADSAccountSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TUAdsGroupSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ADS_TUADSMachineSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TDAttestationPolicyHasApprSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TIAttestationPolicyHasApprSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TIHelperHeadPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUAccProductSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUAttestationPolicySQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUDialogParameterSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUHardwareSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUHelperHeadPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.ATT_TUPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T417F8A7AFDDFC7CAB5315DF3DSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T42CAE7CC4ED0C0A8ACA676A88SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T43769BDD8C7D76F7C2A028E81SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T466C44EA8A4D3BE37F57BAE44SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T473D0BF02E5A45B69D47EA698SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T4906297FA0095B928C0D22E5ESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T492E7D39E636B4AFCD734B416SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T4954C4E8EAFCCD6BC89D4E21FSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T4D8BBDD351E4C2AC00C3FA4C4SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T4EAA84DB630C36DAF8C529932SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T4FCB6A4B24280E57D68698951SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T51DDFD519D0D0D4549F83A0ECSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5235B5D157E9A787C04AA44ABSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T52E3F4D75FFB9821A5B969F8BSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T55FC26C26831774FF3216F3BBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T566473826D1E54DC944245751SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5A02C0F960F6FC1162454A4D7SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5AD66EB14BA05645CF6CF0E9CSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5BEF9F6CE7518DE970F33A611SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5E1068FB36635FE0D4AE78366SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5E2A0FE839E07869673F15105SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5F6AD473564BCE54D231FDB20SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T6530B0C6C5D0CD4132304B156SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T69EBD2189654166448C0A3EFFSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T6B256F72E10E1B1C83DCFC983SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T6B2EC76A1FB0905C349AC5CBASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T6C5CC02FE16641E3F38C39032SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T6D4663A5E7C964A70BB9C2D5BSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.LDP_TATTULDAPAccountSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.RMS_TATTUPersonHasESetSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSB_TATTUUNSAccountBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.DelegableItemSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBMVCustomInfoSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBMVSystemInfoSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSBVDirectAssignWrongSQL expression dependencydbo · OBJECT_OR_COLUMN