Over time data in SQL Server tables needs to be modified. There are two major different aspects of modifying data: updating and deleting. In my last article “Updating SQL Server Data” I discussed using the
UPDATEstatement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use the
DELETEstatement to remove rows from a SQL Server Table.
This stays pretty simple but provides an effective overview of how to keep those tables tidy.