Introducing SQL Server

CHAPTER 8

DML (or Inserts, Updates, and Deletes)

We’ve created a solid database structure, but just as a database is useless without tables, so a table is useless without data. We’ve been using the table editor to add data to tables, but it’s time to introduce the power of the T-SQL language. We’ll look at how we can add data to our tables, edit it, and how we can remove it. We’ll even do a little bit of querying, which will take us nicely into the next chapter.

Let’s add some records!

Reference Data vs. Real Data

Before we add anything to the database, it’s important to understand the difference between reference data and what I call real data. ...