dbo.QBM_FGICodeName
Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- references source dbo.QBM_FCVBinaryToString source text reference
- references source dbo.QBM_FCVStringToHash source text reference
References
Referenced By
- dbo.CPL_FCVRuleGuidToProcName
- dbo.QBM_FGIDashBoardCodeName
- dbo.QER_FCVDynGuidToProcName
- dbo.QER_FCVRuleGUIDToFuncNameReclc
- dbo.QER_FCVRuleGUIDToFunctionName
- dbo.QER_FGIRiskIndexProcname
- dbo.ATT_ZAttHelperFillMakeProc
- dbo.DPR_ZTriggerCreateMembership
- dbo.POL_ZQERPolicyFill
- dbo.POL_ZQERPolicyMakeProc
- dbo.QBM_PIndexCreateGenerated_XA
- dbo.QBM_PIndexCreateGenerated_XI
- dbo.QBM_PIndexCreateGenerated_XO
- dbo.QBM_PIndexCreateGenerated_XR
- dbo.QBM_PIndexCreateGenerated_XX
- dbo.QBM_PRITriggerCreate
- dbo.QBM_PSlotResetOnMissingItem_L
- dbo.QBM_PViewBuild_FromAddOn
- dbo.QBM_ZTriggerWatchCreate
- dbo.QBM_ZTriggerWatchCreate_S
- dbo.QER_P30907EB9FB8232867B_func
- dbo.QER_PSlotResetOnInvalidRoot_L
- dbo.QER_PSQRiskIndexGetUpdate
- dbo.QER_ZDynamicGroupMakeTrigger
- dbo.QER_ZEntitlementSourceMakeProc
- dbo.QER_ZPWOHelperFillMakeProc
Complete Source
1CREATE FUNCTION dbo.QBM_FGICodeName(2 @Prefix varchar(5),3 @SourceString nvarchar(256)4) RETURNS varchar(305)6AS7BEGIN8 DECLARE @erg varchar(30)9 SELECT @erg =10 LEFT('GEN' + '_' + @prefix + SUBSTRING(dbo.QBM_FCVBinaryToString(dbo.QBM_FCVStringToHash(upper(@prefix+@SourceString)),11 0), 3, 30),12 30) endLabel:13 RETURN(@erg)14END
Open raw exported source
1 create function dbo.QBM_FGICodeName( @Prefix varchar(5) , @SourceString nvarchar(256) ) returns varchar(30)as begin declare @erg varchar(302) select @erg = left( 'GEN' + '_' + @prefix + SUBSTRING( dbo.QBM_FCVBinaryToString( dbo.QBM_FCVStringToHash(upper(@prefix+@SourceString)), 0) , 3, 30 )3 , 30 ) endLabel: return (@erg) end 4