You are responsible for importing data into SQL Server 2005 databases. Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.
You need to import the files into the sales database. What should you do?
A.
Create a custom format file, specifying a semicolon as the row terminator.
B.
Use the bcp command, specifying a semicolon as the field terminator.
C.
Use the bcp command with the default arguments.
D.
Use the BULK INSERT statement with the default arguments.
Explanation:
The bcp utility bulk copies data between an instance of Microsoft SQL Server 2005 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.