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

Monday Nov 21st 2005 by DatabaseJournal.com Staff
Share:

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

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved