dbo.QBM_FCVStringToBit

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

NameTypeOutput
bityes
@InputValuenvarcharno

Referenced objects

SchemaObjectColumn/minorClass
No SQL expression dependencies in snapshot.

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_FCVStringToBit (@InputValue nvarchar(64)) returns bit with SCHEMABINDING as begin return( case left(trim(isnull(@InputValue
2, '')), 4) when N'True' then 1 when N'Wahr' then 1 else case when left(trim(isnull(@InputValue, '')), 1) = N'1' then 1 when left(trim(isnull(@InputValue
3, '')), 2) = N'ON' then 1 else 0 end end ) end 
4

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

None extracted.

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

Declared parameters

ParameterTypeDirection
bitOUTPUT
@InputValuenvarchar(64)input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @InputValue

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_FCVListToJobParameterSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.CPL_ZITShopMakeDecisionCRSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.CPL_ZITShopMakeDecisionOCSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.CPL_ZITShopMakeDecisionOHSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PIsForITShopFlagCheckSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopHelperFill_bulkSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopHelperFillAllSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove_bulkSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZAllForPersonInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopCheckSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopCheckDecisionSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopCheckValidSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopCheckWaitingSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopDeleteClosedSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopHelperFill_RecalcSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionCDSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionEXSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionRISQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionSBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionWCSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopOrderAbortSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_ZITShopRepairClosedSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_FTSessionError_SplitSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_FTPWOVisibleForPerson_ISQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T500F503B4FCAB1439F2D3A48FSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5021AFB4B041761EC1F61839ASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T50452A328C7E282EB7AB86A91SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T508DF7ED88458A800972CB535SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T50A4A110603397623955B08D7SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T50BF961DFC426AB2FECA8DA68SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T50C265D36F206E08DA37BFE9FSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T510A25F7B96929CB32011D39FSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T511C0F8605EA1F127F66341B0SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5151DA3B04C823B1D7503437ESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T516F8D02D8A947E6C1982FBEASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T520DB3A9BDA3D9A3CB811BD05SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5268C92936DFA252DAA8D57E7SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5276DF6B0D13B4EEBDF8AD143SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T52B623E98B77D7EEC159471C3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T52C3C308A5DC0195602532339SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T531318728749FC47509159C8CSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T534C34694914FECD9BFD464C7SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T53A648A1D7DE3DEE795E22D42SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5402269F27C8C5DF4C5DCBD1ASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5425F28D4E596CEE2D6BB9755SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5476DE6B7F6D278B6BA72EEF8SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T54A16FAA66A23E4595298A764SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T55029CA63D7971D63E1F96BAASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T559B59BD125649F30618830E9SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T56111844E7CE9B3B23DD83A47SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T563BFB24F67BE223C0B3C9FFASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T56AB24A1A231874C43527FD35SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T56B1683B1A95C71280044E1BASQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T56B764416E4B4E4510000CD99SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T57C5852ECD733EFED139B5E91SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T58676072FA5C8C396989859EBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5879D5B849A2DAEE98D987DFESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T591BD9A08AA97A8FC73A48D93SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5939901692735BFFAA92CBFECSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T594EFD452DD4326FC55F98BA9SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5976C43A4766F085C5B54AD5BSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T59B43D7BDD1F2D7FBC82716DDSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T59C2EAA269B0FDFDFE2DFAAC2SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T59E19F80961056BF1585A632ESQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5A53A61E57A65634F99A6F788SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5A8F133823DC6301A46D0D639SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5ACC5637C02ABEFB39647FC91SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5B2ECF650BDF12BABC6635558SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5B319CA8AD0EEA2FAD9DD3D68SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5B51D195D8E96503958471D46SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5BC79B72B981D1230589D4AC3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5BCA54F6F1FD6DAA0C0C0ECB0SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5BD8627C98DF1FBD01B17A9DBSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5C11D0D26E43547AB2B9F6315SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5CAB339ACBBDDB70767CAC62CSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5CD5B9F09DE529E15A5C19984SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5E10CEB2978D95B344783D750SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5E69941596630EEF61E2DCE16SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5FD175F854D38DD360AB37FA6SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5FE67B4F8DF6EDD02F4ACB7EDSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_T5FEE6493355F569C08A2204B3SQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUHelperHeadOrgSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUHelperHeadPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonInBaseTreeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_TUPersonWantsOrgSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.TSBVAccountTableSQL expression dependencydbo · OBJECT_OR_COLUMN