This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
Generates script to Export all tables to CSV files
2016-03-25 (first published: 2015-01-30)
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-08 (first published: 2009-06-22)