Sometimes while working with databases, it is necessary to import or export large amounts of data.
Those operations are called Bulk Import/Export operations and are an efficient way to copy data between a SQL Server and a data file.
Export large amount of data to CSV
This article explains how to export large amounts of data from one table to a CSV file using MsSQL Server Export Wizard.