sql-query.dev
sql
mysql
sql-server
database
postgresql
mariadb
sqlite
t-sql
sqlalchemy
php
Dark
audit
[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
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:
1