Advertisement

Populating Tables

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

Once you have created the tables in your database, you need to fill them with data. There are several ways to do this. First, you can use a Transact-SQL INSERT statement, which comes in many flavors. Second, you can use the BULK INSERT statement, introduced in version 7.0. Third, you can use the tried-and-true bulk copy utility (bcp), the progenitor of the BULK INSERT statement. (This one has been around since the Sybase days and is not part of Transact-SQL.) Finally, you can use Data Transformation Services (DTS), also introduced in version 7.0. DTS offers a broad range of ways to load a table.

Keywords

Identity Column Temporary Table Plain Text File Single Insert Bulk Load 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Itzik Ben-Gan and Tom Moreau 2000

Authors and Affiliations

  • Itzik Ben-Gan
  • Tom Moreau

There are no affiliations available

Personalised recommendations