Back to OIM Explorer

dbo.QBM_PHistoryColumnSetDefault

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL18 lines
1CREATE PROCEDURE QBM_PHistoryColumnSetDefault2AS3BEGIN4  DECLARE @XUser nvarchar(64) = object_name(@@procid)5  DECLARE @Xdate datetime = getutcdate()6  UPDATE dialogcolumn7  SET isToWatch = 1,8  IsToWatchDelete = 1,9  XDateUpdated = @Xdate,10  XUserUpdated = @XUser11  FROM dialogcolumn c12  JOIN dialogtable t13    ON c.uid_dialogtable = t.uid_dialogtable14  JOIN QBMVDefaultHistoryColumns v15    ON t.TableName = v.TableName AND c.columnname = v.columnname AND v.ColumnName NOT IN('XMarkedForDeletion')16  WHERE17    (c.isToWatch = 0 OR c.isToWatchDelete = 0)18END
Open raw exported source
SQL · Raw5 lines
1   create   procedure QBM_PHistoryColumnSetDefault as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate2() update dialogcolumn set isToWatch = 1 , IsToWatchDelete = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser  from dialogcolumn c join dialogtable t 3on c.uid_dialogtable = t.uid_dialogtable join QBMVDefaultHistoryColumns v on t.TableName = v.TableName and c.columnname = v.columnname  and v.ColumnName4 not in ('XMarkedForDeletion') where ( c.isToWatch = 0 or c.isToWatchDelete = 0 )  end 5