Question
bcp versus BULK INSERT: how do their execution contexts and best uses differ?
Answer
bcp is a client utility that exports or imports through a client connection; BULK INSERT is a T-SQL statement executed by the Database Engine. Use bcp for command-line pipelines and exports; use BULK INSERT for server-side, database-controlled loads.