O'Reilly logo

Introducing SQL Server by Mike McQuillan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 8

image

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required