Multiple choice technology web technology

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. Use the bcp command

  2. Use the BULKINSERT statement

  3. Create a custom format file

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

Both bcp (Bulk Copy Program command-line utility) and BULK INSERT (T-SQL statement) can import data from text files into SQL Server. The bcp utility is commonly used for batch file processing and is well-suited for automated imports from external sources like store transaction files. BULK INSERT is equally valid but is T-SQL based. Given the scenario of receiving files from multiple stores, bcp is a reasonable choice for command-line batch processing.

Keep practicing — related questions