Chapter III.7. Modifying Your Data

Most databases are dynamic — that is, the data changes. The exception is an archive database that holds historical information. Rewriting history is not a good idea!

Three primary commands are used to change data in a database: INSERT to add data, UPDATE to modify data, and DELETE to remove data. Each of these commands is called a Data Manipulation Language (DML) command. In this chapter, we cover the basics of INSERT, UPDATE, and DELETE.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.