Multiple choice technology databases

You are importing data into SQL server 2005 database. You are receiving text files that contain Sales transactions from stores across the city. You need to import the files into Sales Database. What should you do?

  1. (a) Use the bcp command

  2. (b) Use the BULKINSERT statement

  3. (c) Create a custom format file

  4. (d) None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The bcp (Bulk Copy Program) utility is specifically designed for bulk importing data from text files into SQL Server. It's a command-line tool optimized for high-volume data transfer and handles various text formats. BULK INSERT is a T-SQL statement that performs similar function but requires the file to be accessible from the server. Both are valid, but bcp is the most direct answer for 'receiving text files' that need import. Custom format files are used with both bcp and BULK INSERT to define column mappings, not a standalone solution.

Keep practicing — related questions