Greg Larsen fills us in on an important command:
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
UPDATE
statement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use theDELETE
statement to remove rows from a SQL Server Table.
This stays pretty simple but provides an effective overview of how to keep those tables tidy.