CHAPTER 9
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 ...
Get Introducing SQL Server 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.
