Back to OIM Explorer

dbo.QER_PDefaultHardwaretypeAssign

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 951 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

  • No direct source references extracted.

Complete Source

SQL38 lines
1CREATE PROCEDURE QER_PDefaultHardwaretypeAssign2AS3BEGIN4  DECLARE @XUser nvarchar(64) = object_name(@@procid)5  DECLARE @Xdate datetime = getutcdate()6  SET XACT_ABORT OFF7  BEGIN TRY8    UPDATE Hardware9    SET uid_Hardwaretype = 'QER-B5BC91B95707471ABB9EBC00898C82ED',10    XDateUpdated = @Xdate,11    XUserUpdated = @XUser12    WHERE13      isserver=1 AND ispc= 0 AND isnull(uid_Hardwaretype,14    '') = ''15    UPDATE Hardware16    SET uid_Hardwaretype = 'QER-F098E96A4CA84FBBAFD7151436C4DD93',17    XDateUpdated = @Xdate,18    XUserUpdated = @XUser19    WHERE20      isPC=1 AND isserver = 0 AND isnull(uid_Hardwaretype,21    '') = ''22    UPDATE Hardware23    SET uid_Hardwaretype = 'QER-8A0F010A2BA54031A2320E078A6D8E26',24    XDateUpdated = @Xdate,25    XUserUpdated = @XUser26    WHERE27      isPC=0 AND isserver=0 AND isnull(uid_Hardwaretype,28    '') = ''29  END TRY30  BEGIN CATCH31    EXEC QBM_PSessionErrorAdd DEFAULT32    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()33    RAISERROR(@Rethrow,34    18,35    1)36      WITH NOWAIT37  END CATCH38END
Open raw exported source
SQL ยท Raw8 lines
1  create   procedure QER_PDefaultHardwaretypeAssign as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate2() SET XACT_ABORT OFF BEGIN TRY update Hardware set uid_Hardwaretype = 'QER-B5BC91B95707471ABB9EBC00898C82ED'   , XDateUpdated = @Xdate , XUserUpdated 3= @XUser where isserver=1 and ispc= 0 and isnull(uid_Hardwaretype,'') = '' update Hardware set uid_Hardwaretype = 'QER-F098E96A4CA84FBBAFD7151436C4DD93'4   , XDateUpdated = @Xdate , XUserUpdated = @XUser where isPC=1 and isserver = 0 and isnull(uid_Hardwaretype,'') = '' update Hardware set uid_Hardwaretype5 = 'QER-8A0F010A2BA54031A2320E078A6D8E26'   , XDateUpdated = @Xdate , XUserUpdated = @XUser where isPC=0 and isserver=0 and isnull(uid_Hardwaretype,'')6 = '' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 71) WITH NOWAIT END CATCH end 8