Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
SQL SERVER – Troubleshooting Common CSV Import Issues
Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
To Split Comma Separated Value String inputs, I use STRING_SPLIT with CROSS APPLY. The example associates each class with its student.
BULK INSERT With FORMAT CSV and FIELDQUOTE for Quoted Files
A comma inside a quoted name can break a CSV load without any error. Here is how FIELDQUOTE fixes it, and how to validate what arrives.
SQL SERVER – SSMS Trick – Generating CSV file using Management Studio
Readers asked why use SQLCMD or BCP at all. Generating CSV file output is easy in SSMS: set Results to Text as comma delimited in Tools, Options.
MySQL – Export the Resultset to CSV file
In MySQL you can export a resultset to CSV in more than one way. I show two methods: the Export option in Workbench and the INTO OUTFILE command.
Exporting CSV Files Without Losing Leading Zeros or Dates
A postal code like 00501 turns into 501 in a spreadsheet. See where the zero is lost, how to build a correct CSV line, and why quotes alone do not help.