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 9

image

Bulk Inserting Data

In the last chapter, we saw how we can manipulate records using INSERT INTO, UPDATE, and DELETE, and we used these statements to populate our reference data tables. Now let’s add some contacts and their related information to our database. We could do this with these three statements—and we will—but we can also use SQL Server’s BULK INSERT statement to add records via external files.

We’ll start by adding some data using the BULK INSERT statement, and then we’ll create a script to manually add a contact. We’ll cover a lot of SQL Server functionality in this chapter, so hang on to your hat!

The BULK INSERT Statement ...

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