dbo.QBM_FGIColumnExists
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_FSQTriggerWatchMemberShip
- dbo.QBM_FGIColumnExistsInSchema
- dbo.QBM_FSQFKCheckDynamic
- dbo.QBM_FSQFKCheckFix
- dbo.QBM_FSQTriggerSplittedLookup
- dbo.QBM_FSQTriggerWatchXOrigin
- dbo.QBM_FSQXMarkedForDeletionChg
- dbo.DPR_PMemberShipActionCleanUp
- dbo.QBM_PBufferC_ProcessOneColumn
- dbo.QBM_PBufferC_RestoreOneColumn
- dbo.QBM_PBufferT_FillTable
- dbo.QBM_PBufferT_FillTable_CCC
- dbo.QBM_PBufferT_ProcessInsert
- dbo.QBM_PBufferT_ProcessUpdate
- dbo.QBM_PCheckSameCase_138
- dbo.QBM_PCheckSameCase_38
- dbo.QBM_PColumnChangeDataType
- dbo.QBM_PColumnSQLReplace
- dbo.QBM_PDeleteDeep_L
- dbo.QBM_PFDA25F6EA8E748702E6D119_1
- dbo.QBM_PFDA25F6EA8E748702E6D119_2
- dbo.QBM_PForeignKeyEmptySetNull
- dbo.QBM_PForeignKeyObjectKeyNoRef
- dbo.QBM_PGUIDReplaceLight_Multi
- dbo.QBM_PMNTableInsert
- dbo.QBM_PMNTableInsertOwnPK
- dbo.QBM_PMNTableOriginUpdate
- dbo.QBM_PObjectExistsInDatabase
- dbo.QBM_PSlotResetOnMissingItem_L
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_ZCheckDefaultZero
- dbo.QBM_ZCheckInvalidDate
- dbo.QBM_ZObjectKeyRepair
- dbo.QBM_ZXMarkedForDeletionPush
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_PQERRiskIndexMakeProc
- dbo.QER_TUOrgRootAssign
- dbo.RMS_TIESetHasEntitlement
Complete Source
1CREATE FUNCTION dbo.QBM_FGIColumnExists(2 @TableName varchar(30),3 @columnname varchar(30)4) RETURNS BIT5AS6BEGIN7 DECLARE @erg BIT = 08 IF @TableName IN(9 SELECT TableName10 FROM QBM_VStartupTables)11 BEGIN12 IF EXISTS(13 SELECT TOP 1 114 FROM QBM_VSchemaColumns15 WHERE16 table_name = @TableName AND column_name = @columnname)17 BEGIN18 SELECT @erg = 119 END20 END21 ELSE22 BEGIN23 IF EXISTS(24 SELECT TOP 1 125 FROM dialogColumn c26 WITH(readpast)27 JOIN DialogTable t28 WITH(readpast)29 ON c.UID_DialogTable = t.UID_DialogTable30 WHERE31 t.TableName = @TableName AND c.ColumnName = @columnname)32 BEGIN33 SELECT @erg = 134 END35 END36 ende:37 RETURN(@erg)38ENDOpen raw exported source
1 create function dbo.QBM_FGIColumnExists (@TableName varchar(30) , @columnname varchar(30) ) returns bit as begin declare @erg bit = 0 if @TableName2 in (select TableName from QBM_VStartupTables) begin if exists (select top 1 1 from QBM_VSchemaColumns where table_name = @TableName and column_name = 3@columnname ) begin select @erg = 1 end end else begin if exists (select top 1 1 from dialogColumn c with (readpast) join DialogTable t with (readpast)4 on c.UID_DialogTable = t.UID_DialogTable where t.TableName = @TableName and c.ColumnName = @columnname ) begin select @erg = 1 end end ende: return(@erg5) end 6