Stored procedure: Simplify comma-separated value (CSV) exports

November 21, 2005

[From SearchSQLServer.com]

This tip continues the system stored procedure series with a routine to create a comma-delimited file containing data from several columns.

A comma-delimited data file, also known as a comma-separated value (CSV) file, is typically opened with Microsoft Excel and it often contains a simple data extract. It gets its name from the fact that a comma is placed between adjacent column values within each row. Excel uses each comma as a signal to place the following value in the next column of the worksheet.

The article continues at http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1145349,00.html