Using Views
bcp can use views to export data from a database. This means an export of data can be a result set of data from multiple tables (and with distributed queries, even multiple servers).
You can also use a view with bcp to load data back into tables. However, as is the case with normal T-SQL inserts, you can load into only one of the underlying tables at a time.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
