Sqlserver database table export CSV file

1. The first way is convenient and fast.

Direct Select query the data of the data table, and save the selected data as a CSV file, which is convenient and fast, which is suitable for importing data with a small amount of data. Too much data will bring more pressure to sqlserver services, and it also consumes memory, resulting in memory corruption!

2. Mode 2. Sqlserver's own export tool, which is suitable for exporting a large amount of data.

2.1 Select Database-- > data right-- > Task-- > Import data

2.2 Select "next"

2.3 Select a data source

2.4 Select an export destination

2.5 Click "Browse" to select the file save type

2.6 choose the next step directly.

2.7 Select the table or view to export

2.8 Select the data table to export, or click "Edit Mapping" to edit and select the exported fields, and then the next step

2.10 "done"

2.11 Export succeeded