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