Back to OIM Explorer

dbo.ATT_P600B8EB3A312074D1A10A4A_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 903 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_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL41 lines
1CREATE PROCEDURE ATT_P600B8EB3A312074D1A10A4A_(2  @uid_AttestationPolicy varchar(38)3)4AS5BEGIN6  DECLARE @ergebnis int = 17  DECLARE @Work QBM_YParameterList8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @Work(Parameter2)11    SELECT TOP 2000 c.UID_AttestationCase12    FROM AttestationCase c13    WHERE14      c.UID_AttestationPolicy = @uid_AttestationPolicy15    SELECT @ergebnis = @@ROWCOUNT16    IF @ergebnis = 017    BEGIN18      GOTO endLabel19    END20    DELETE AttestationCaseHasMControl21    FROM AttestationCaseHasMControl ac22      WITH(forceSeek)23    JOIN @Work w24      ON ac.UID_AttestationCase = w.Parameter225    DELETE AttestationCase26    FROM AttestationCase ac27      WITH(forceseek)28    JOIN @Work w29      ON ac.UID_AttestationCase = w.Parameter2 option(maxdop 1)30  END TRY31  BEGIN CATCH32    EXEC QBM_PSessionErrorAdd DEFAULT33    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()34    RAISERROR(@Rethrow,35    18,36    1)37      WITH NOWAIT38  END CATCH39  endLabel:40  RETURN(@Ergebnis)41END
Open raw exported source
SQL ยท Raw7 lines
1      create   procedure ATT_P600B8EB3A312074D1A10A4A_(@uid_AttestationPolicy varchar(38) ) as begin declare @ergebnis int = 1 declare @Work QBM_YParameterList2  SET XACT_ABORT OFF BEGIN TRY insert into @Work (Parameter2 ) select top 2000 c.UID_AttestationCase from AttestationCase c where c.UID_AttestationPolicy3 = @uid_AttestationPolicy select @ergebnis = @@ROWCOUNT if @ergebnis = 0 begin goto endLabel end  delete AttestationCaseHasMControl from AttestationCaseHasMControl4 ac with (forceSeek) join @Work w on ac.UID_AttestationCase = w.Parameter2  delete AttestationCase from AttestationCase ac with (forceseek) join @Work 5w on ac.UID_AttestationCase = w.Parameter2  option (maxdop 1) END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow6() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return (@Ergebnis) end 7