Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.

Loading CSV Files Using Dynamic SQL

In this article, we will see of a quick way to load CSV files from a directory on your computer.

'Comedy Limited' with SQL Server

Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.

Importing Tricky CSV Files with PowerShell

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell

Historical Stock Prices and Volumes from Python to a CSV File

Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.

SQL Server R Services: Working with Multiple Data Sets

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.

Loading CSVs

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.

Dynamic sql for convert SQL statement to txt/csv file

Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.

Get a CSV list of columns in a table

Short little script to get the columns in a table in order into a CSV format.

Can be useful for select or insert statements.