SQL: Create zombies (rows that won't die) in SQL Server by using INSTEAD OF triggers

added by DotNetKicks
8/19/2019 3:43:52 PM

126 Views

I've seen a number of interesting discussions lately around how to handle deletes in database tables. One discussion in Stack Overflow had a variety of suggestions. One easy option in SQL Server 2016 and later is to use temporal tables as they'll keep the history for you.


0 comments