Bulk Copy - Use BCP from SQL to concat databases

Introduction This post’s goal is to introduce you to Bulk Copy. We’ll create a SQL query which is going to concatenate several attached databases and extract the data to an output csv file. The first goal is to demonstrate how to use Bulk Copy as well as solving an issue that I sometime encountered for…

1