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.
KeywordsIdentity Column Temporary Table Plain Text File Single Insert Bulk Load
Unable to display preview. Download preview PDF.