A practical pattern for SQL Server stored procedures that modify production data: default the write gate to 0, and use the ELSE branch to return diagnostic result sets showing exactly what would change before it does.

This is why I structure stored procedures with temp tables instead of variables. It's not about performance. It's not about best practices. It's about getting out of the office on time.