Software developers use SQL's Insert statement to add records to a database. For example, to add a new record to a table called "customers," you could an Insert statement such as the following: ...

You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.