Back to OIM Explorer

dbo.QBM_ZConfigParmCheck

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.316 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_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL61 lines
1CREATE PROCEDURE QBM_ZConfigParmCheck(2  @SlotNumberDummy int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @lauf int10  DECLARE @DialogConfigparm QBM_YSingleGUID11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  BEGIN TRY14    INSERT INTO @DialogConfigparm(UID_SingleGuid,15    IntProperty,16    BitProperty)17    SELECT18      uid_configparm,19      enabled,20      enabled21    FROM dialogconfigparm22    WHERE23      uid_parentconfigparm IS NULL24    SELECT @lauf = 125    WHILE @lauf > 026    BEGIN27      INSERT INTO @DialogConfigparm(UID_SingleGuid,28      IntProperty,29      BitProperty)30      SELECT31        x.uid_configparm,32        x.enabled,33        convert(BIT,34        convert(int, x.enabled) & convert(int, p.BitProperty))35      FROM dialogconfigparm x36      JOIN @DialogConfigparm p37        ON p.UID_SingleGuid = x.UID_ParentConfigparm38      WHERE39        NOT EXISTS(40      SELECT TOP 1 141      FROM @DialogConfigparm y42      WHERE43        y.UID_SingleGuid = x.uid_configparm)44      SELECT @lauf = @@rowcount45    END46    UPDATE DialogConfigParm47    SET IsEnabledResulting = c.BitProperty,48    XDateUpdated = @Xdate49    FROM DialogConfigParm,50    @DialogConfigParm c51    WHERE52      DialogConfigParm.UID_ConfigParm = c.UID_SingleGuid AND DialogConfigParm.IsEnabledResulting <> c.BitProperty53  END TRY54  BEGIN CATCH55    EXEC QBM_PSessionErrorAdd DEFAULT56    RAISERROR('',57    18,58    1)59      WITH NOWAIT60  END CATCH61END
Open raw exported source
SQL ยท Raw10 lines
1      create   procedure QBM_ZConfigParmCheck ( @SlotNumberDummy int , @dummy1 varchar(38) , @dummy2 varchar(38) , @GenProcIDDummy varchar(38) )2 as begin declare @lauf int declare @DialogConfigparm QBM_YSingleGUID  declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate3() BEGIN TRY insert into @DialogConfigparm (UID_SingleGuid ,  IntProperty , BitProperty  ) select uid_configparm,  enabled, enabled   from dialogconfigparm4 where uid_parentconfigparm is null select @lauf = 1 while @lauf > 0 begin  insert into @DialogConfigparm (UID_SingleGuid ,  IntProperty , BitProperty 5) select x.uid_configparm,  x.enabled, convert(bit, convert(int, x.enabled) & convert(int, p.BitProperty )) from dialogconfigparm x join @DialogConfigparm6 p on p.UID_SingleGuid  = x.UID_ParentConfigparm where Not exists (select top 1 1 from @DialogConfigparm y where y.UID_SingleGuid  = x.uid_configparm )7 select @lauf = @@rowcount  end  update DialogConfigParm set IsEnabledResulting = c.BitProperty  , XDateUpdated = @Xdate   from DialogConfigParm, @DialogConfigParm8 c where DialogConfigParm.UID_ConfigParm = c.UID_SingleGuid  and DialogConfigParm.IsEnabledResulting <> c.BitProperty  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd9 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 10