dbo.QBM_FGITableName
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
- No typed edges extracted for this source.
References
- No direct source references extracted.
Referenced By
- dbo.DPR_FSQTriggerRIMemberShip
- dbo.DPR_FSQTriggerWatchMemberShip
- dbo.QBM_PObjectExistsInDatabase
- dbo.QBM_PTriggersInactiveForTable
- dbo.QBM_PViewBuildP_intern
- dbo.QBM_PViewBuildR_intern
- dbo.QBM_PViewBuildU_intern
- dbo.QBM_PViewBuildV_intern
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_RXDateSubItemUpdate
- dbo.QBM_RXDateSubItemUpdateFU
- dbo.QBM_ZViewBuildP
- dbo.QBM_ZViewBuildR
- dbo.QBM_ZViewBuildU
- dbo.QBM_ZViewBuildV
- dbo.QBM_ZXMarkedForDeletionPush
- dbo.QER_PITShopProductNodeMove
- dbo.QER_ZDynamicGroupMakeTrigger
- dbo.QER_FTDynGroupColForImmediate
- dbo.DPR_TDDPRNameSpaceHasDialogTab
- dbo.DPR_TIDPRNameSpaceHasDialogTab
- dbo.DPR_TUDPRNameSpaceHasDialogTab
- dbo.QBM_TDAssembly_DialogColumn
- dbo.QBM_TDAssembly_DialogTable
- dbo.QBM_TDAssembly_Job
- dbo.QBM_TDAssembly_Jobchain
- dbo.QBM_TDAssembly_JobEventGen
- dbo.QBM_TDAssembly_JobRunparameter
- dbo.QBM_TDAssembly_QBMEvent
- dbo.QBM_TDQBMUniqueGroup
- dbo.QBM_TDQBMUniqueGroupHasColumn
- dbo.QBM_TIAssembly_DialogColumn
- dbo.QBM_TIAssembly_DialogTable
- dbo.QBM_TIAssembly_Job
- dbo.QBM_TIAssembly_JobChain
- dbo.QBM_TIAssembly_JobEventGen
- dbo.QBM_TIAssembly_JobRunparameter
- dbo.QBM_TIAssembly_QBMEvent
- dbo.QBM_TIDialogTable
- dbo.QBM_TIQBMUniqueGroup
- dbo.QBM_TIQBMUniqueGroupHasColumn
- dbo.QBM_TUAssembly_DialogColumn
- dbo.QBM_TUAssembly_DialogTable
- dbo.QBM_TUAssembly_Job
- dbo.QBM_TUAssembly_JobChain
- dbo.QBM_TUAssembly_JobEventGen
- dbo.QBM_TUAssembly_JobRunparameter
- dbo.QBM_TUAssembly_QBMEvent
- dbo.QBM_TUDialogColumn
- dbo.QBM_TUDialogTable
- dbo.QBM_TUQBMUniqueGroup
- dbo.RMS_TIESetHasEntitlement
Complete Source
1CREATE FUNCTION dbo.QBM_FGITableName(2 @UID_DialogTable varchar(38)3) RETURNS varchar(304)5AS6BEGIN7 DECLARE @erg varchar(30) = NULL8 SELECT TOP 1 @erg = t.TableName9 FROM DialogTable t10 WITH(readpast)11 WHERE12 t.UID_DialogTable = @UID_DialogTable13 IF @erg IS NULL14 BEGIN15 SELECT16 @erg = SUBSTRING(@UID_DialogTable,17 7,18 30)19 IF NOT EXISTS(20 SELECT TOP 1 121 FROM sys.objects o22 WHERE23 o.type IN('U', 'V') AND o.name = @erg)24 BEGIN25 SELECT @erg = ''26 END27 END28 ende:29 RETURN(@erg)30ENDOpen raw exported source
1 create function dbo.QBM_FGITableName(@UID_DialogTable varchar(38) ) returns varchar(30) as begin declare @erg varchar(30) = null select top2 1 @erg = t.TableName from DialogTable t with (readpast) where t.UID_DialogTable = @UID_DialogTable if @erg is null begin select @erg = SUBSTRING(@UID_DialogTable3, 7, 30) if not exists (select top 1 1 from sys.objects o where o.type in ('U', 'V') and o.name = @erg ) begin select @erg = '' end end ende: return(@erg4) end 5