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.