Back to OIM Explorer

dbo.QBM_PColumnSchemaDataTypeCorr

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.026 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL38 lines
1CREATE PROCEDURE QBM_PColumnSchemaDataTypeCorr(2  @ModulePattern varchar(3) = '%'3)4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @Xdate datetime = getutcdate()8  SET XACT_ABORT OFF9  BEGIN TRY10    UPDATE DialogColumn11    SET SchemaDataType = x.DATA_TYPE,12    XDateUpdated = @Xdate,13    XUserUpdated = @XUser,14    SchemaDataLen = CASE15    WHEN x.CHARACTER_MAXIMUM_LENGTH IS NULL THEN16    017    ELSE x.CHARACTER_MAXIMUM_LENGTH18    END19    FROM DialogColumn c20    JOIN DialogTable t21      ON c.UID_DialogTable = t.UID_DialogTable22    JOIN INFORMATION_SCHEMA.COLUMNS x23      ON t.TableName = x.TABLE_NAME AND c.ColumnName = x.COLUMN_NAME24    WHERE25      (isnull(c.SchemaDataType, '') <> x.DATA_TYPE OR isnull(c.SchemaDataLen, 0) <> isnull(x.CHARACTER_MAXIMUM_LENGTH,26    0) OR c.SchemaDataLen IS NULL) AND dbo.QBM_FCVGUIDToModuleOwner(c.uid_dialogColumn) LIKE @ModulePattern27  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()31    RAISERROR(@Rethrow,32    18,33    1)34      WITH NOWAIT35  END CATCH36  ende:37  RETURN38END
Open raw exported source
SQL ยท Raw8 lines
1  create   procedure QBM_PColumnSchemaDataTypeCorr (@ModulePattern varchar(3) = '%' ) as begin declare @XUser nvarchar(64) = object_name(@@procid2) declare @Xdate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY update DialogColumn set SchemaDataType = x.DATA_TYPE  , XDateUpdated = @Xdate , XUserUpdated3 = @XUser , SchemaDataLen = case when x.CHARACTER_MAXIMUM_LENGTH is null then 0 else x.CHARACTER_MAXIMUM_LENGTH end from DialogColumn c join DialogTable4 t on c.UID_DialogTable = t.UID_DialogTable join INFORMATION_SCHEMA.COLUMNS x on t.TableName = x.TABLE_NAME and c.ColumnName = x.COLUMN_NAME where ( isnull5(c.SchemaDataType, '') <> x.DATA_TYPE or isnull(c.SchemaDataLen, 0) <> isnull(x.CHARACTER_MAXIMUM_LENGTH, 0) or c.SchemaDataLen is null ) and dbo.QBM_FCVGUIDToModuleOwner6(c.uid_dialogColumn) like @ModulePattern END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow7() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 8