audit

[1/1]

  1. Shadow Tables vs. Generic Audit Table: Choosing the Right Approach for Database Change Tracking
    Concept: Create a separate table for each table you want to audit. This shadow table mirrors the original table structure
  2. Demystifying @@ROWCOUNT: Your Guide to Tracking Deletions in Stored Procedures
    Here are two common approaches to count the number of deleted rows within a SQL Server stored procedure:Using @@ROWCOUNT: