Back to OIM Explorer

dbo.QBM_PDialogDatabaseInitialInfo

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.121 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_FGIDBDataOrigin source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL62 lines
1CREATE PROCEDURE QBM_PDialogDatabaseInitialInfo2AS3BEGIN4  DECLARE @UID_NewObject varchar(38)5  DECLARE @xdate datetime = getutcdate()6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  SET XACT_ABORT OFF8  BEGIN TRY9    SET nocount10      ON11    IF NOT EXISTS(12      SELECT TOP 1 113      FROM dialogdatabase)14    BEGIN15      SELECT @UID_NewObject = newid()16      INSERT INTO dialogdatabase(UID_Database,17      IsMainDatabase,18      Description,19      ConnectionString,20      ConnectionProvider,21      XObjectKey,22      ModuleOwner,23      UID_DialogAuthentifier,24      UID_DialogCultureDefault,25      XUserInserted,26      XUserUpdated,27      XDateInserted,28      XDateUpdated,29      productionLevel,30      CustomerPrefix,31      IsJobServiceDisabled,32      DataOrigin)33      VALUES(@UID_NewObject,34      1,35      N 'Main Database',36      NULL,37      NULL,38      CONCAT('<Key><T>DialogDatabase</T><P>', @UID_NewObject, '</P></Key>'),39      'CCC',40      'QBM-740AF63FCA9D40E1A9A28CF076B36BBD',41      'QBM-CULT-en-US',42      @XUser,43      @XUser,44      @xdate,45      @xdate,46      0,47      'CCC',48      1,49      dbo.QBM_FGIDBDataOrigin())50    END51  END TRY52  BEGIN CATCH53    EXEC QBM_PSessionErrorAdd DEFAULT54    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()55    RAISERROR(@Rethrow,56    18,57    1)58      WITH NOWAIT59  END CATCH60  ende:61  RETURN62END
Open raw exported source
SQL ยท Raw9 lines
1   create   procedure QBM_PDialogDatabaseInitialInfo as begin declare @UID_NewObject varchar(38) declare @xdate datetime = getutcdate() declare 2@XUser nvarchar(64) = object_name(@@procid) SET XACT_ABORT OFF BEGIN TRY set nocount on if not exists (select top 1 1 from dialogdatabase ) begin select3 @UID_NewObject = newid() insert into dialogdatabase (UID_Database, IsMainDatabase, Description , ConnectionString, ConnectionProvider , XObjectKey , ModuleOwner4, UID_DialogAuthentifier , UID_DialogCultureDefault , XUserInserted, XUserUpdated, XDateInserted, XDateUpdated , productionLevel, CustomerPrefix , IsJobServiceDisabled5 , DataOrigin ) values (@UID_NewObject, 1, N'Main Database', null, null , concat('<Key><T>DialogDatabase</T><P>', @UID_NewObject ,'</P></Key>') , 'CCC'6, 'QBM-740AF63FCA9D40E1A9A28CF076B36BBD'  , 'QBM-CULT-en-US' , @XUser, @XUser, @xdate, @xdate , 0, 'CCC' , 1 , dbo.QBM_FGIDBDataOrigin() ) end END TRY 7BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT8 END CATCH ende: return end 9