dbo.QBM_FGISessionContext
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_FCVStringToGUID source text reference
- references source dbo.QBM_FGIUTCDate source text reference
References
Referenced By
- dbo.DPR_FSQTriggerWatchMemberShip
- dbo.QBM_FCVSessionErrorToMVP
- dbo.QBM_FGISessionErrorRaw
- dbo.QBM_FSQBufferConfigSaveOrigin
- dbo.QBM_FSQTriggerDef
- dbo.QBM_FSQXDateSubItemUpdate
- dbo.ADS_ZGroupInADSGroup
- dbo.ATT_PAttestationCaseCreate
- dbo.ATT_PAttestationCaseCreate_i
- dbo.ATT_PAttestationCaseDeleteOld
- dbo.ATT_PAttestationHelperFill
- dbo.ATT_PHelperAttestationPolicy
- dbo.ATT_ZAttestationCheckValid
- dbo.ATT_ZAttestationObjectPreProp
- dbo.ATT_ZAttestationReminder
- dbo.ATT_ZAttestationReset
- dbo.ATT_ZAttestationWzParmPreProp
- dbo.CPL_PSubRuleFillPerson_i
- dbo.CPL_ZAllForOnePerson
- dbo.CPL_ZITShopMakeDecisionCR
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.CPL_ZSubRuleFillObject
- dbo.LDP_ZGroupInLDAPGroup
- dbo.POL_ZQERPolicyFill
- dbo.QBM_PColumnCheckBlobExternal
- dbo.QBM_PDBQCS_CurrentRestore
- dbo.QBM_PDBQCS_SlotExec
- dbo.QBM_PDBQCS_SlotRunner
- dbo.QBM_PDBQueueCalculateDelta
- dbo.QBM_PDBQueueCompress
- dbo.QBM_PDBQueueInsert_Bulk
- dbo.QBM_PDBQueueInsert_Int
- dbo.QBM_PDBQueueInsert_Single
- dbo.QBM_PDBQueuePrepareForCompiler
- dbo.QBM_PDialogColumnDelete
- dbo.QBM_PDialogColumnInsert
- dbo.QBM_PDialogUserInGroupCorrect
- dbo.QBM_PDynamicUserForPerson
- dbo.QBM_PExecuteSQLMulti
- dbo.QBM_PIndexRebuild
- dbo.QBM_PJobCreate
- dbo.QBM_PJobQueueInit_i
- dbo.QBM_PJobQueueLoad
- dbo.QBM_PJobqueueoverViewFill
- dbo.QBM_PJobQueueStatsShrink
- dbo.QBM_PMigrationNotReadyForComp
- dbo.QBM_PMNTableDelete
- dbo.QBM_PMNTableInsert
- dbo.QBM_PMNTableInsertOwnPK
- dbo.QBM_PMNTableOriginUpdate
- dbo.QBM_PModuleDependCollFill
- dbo.QBM_PPrePropCheckSyntax
- dbo.QBM_PQBMServerHasJobService
- dbo.QBM_PScheduleCheck
- dbo.QBM_PScheduleStartJob
- dbo.QBM_PSessionErrorClean
- dbo.QBM_PTableStatistics
- dbo.QBM_PTempQueueEnd
- dbo.QBM_PTriggersInactiveForTable
Complete Source
1CREATE FUNCTION dbo.QBM_FGISessionContext(2 @Key nvarchar(32)3) RETURNS varchar(10004)5AS6BEGIN7 DECLARE @erg varchar(1000)8 DECLARE @key_intern nvarchar(32)9 SELECT10 @key_intern = upper(CASE isnull(@Key, '')11 WHEN '' THEN12 'GenProcID'13 ELSE @Key14 END)15 SELECT16 @erg = isnull(convert(varchar(1000), SESSION_CONTEXT(@key_intern)),17 '')18 IF @erg = ''19 BEGIN20 IF @key_intern = 'GENPROCID'21 BEGIN22 SELECT23 @erg = dbo.QBM_FCVStringToGUID('',24 CONCAT(convert(varchar, dbo.QBM_FGIUTCDate(), 127), str(@@spid)))25 EXEC sp_set_session_context @Key_intern,26 @erg27 END28 IF @key_intern = 'XUSER'29 BEGIN30 SELECT @erg =31 LEFT(CONCAT('l:', rtrim(isnull(loginame, '')), '|m:', rtrim(isnull(net_address, '')), '|h:', rtrim(isnull(HostName,32 '')), '|p:', rtrim(isnull(program_name, ''))),33 64)34 FROM sys.sysprocesses35 WHERE36 spid = @@spid37 END38 END39 RETURN(@erg)40ENDOpen raw exported source
1 create function dbo.QBM_FGISessionContext (@Key nvarchar(32)) returns varchar(1000) as begin declare @erg varchar(1000) declare @key_intern2 nvarchar(32) select @key_intern = upper( case isnull(@Key, '') when '' then 'GenProcID' else @Key end ) select @erg = isnull(convert(varchar(1000), SESSION_CONTEXT3(@key_intern)), '') if @erg = '' begin if @key_intern = 'GENPROCID' begin select @erg = dbo.QBM_FCVStringToGUID('', concat( convert(varchar, dbo.QBM_FGIUTCDate4(), 127) , str(@@spid) ) ) EXEC sp_set_session_context @Key_intern, @erg end if @key_intern = 'XUSER' begin select @erg = left( concat('l:' , rtrim(isnull5(loginame,'')) , '|m:' , rtrim(isnull(net_address,'')) , '|h:' , rtrim(isnull(HostName,'')) , '|p:' , rtrim(isnull(program_name, '')) ) , 64 ) from sys.sysprocesses6 where spid = @@spid end end return (@erg) end 7