As a developer we may need to convert csv to sql data table every now and then. There are many methods to implement it. In others article of mind, I did shared you how to generate csv form table by using stored procedure. Now, I would like to share you how to retrieve table data from csv text by using stored procedure.

A comma-separated values (CSV) file is a simple text format for tabula data. It is a simple and widely used to transfer information from a database to others program such as spreadsheet. I know that you can use BCP (Bulk Copy Program) command to create CSV files. You can also use DTS or SSIS to do that. But Now, I would like to show the alternative way to generate csv by using Stored Procedure.