Creating a CSV file in a SQL Server stored procedure

Question

Is it possible to create a CSV file from a stored procedure?

I need to create a CSV file with data from a table, that is retrieved in a stored procedure

Alan Fisher · Accepted Answer · 2013-02-01 21:42:07Z

2

I got this to work on a simple Stored Procedure, replace "YourDatabase.dbo.YourSproc"

DECLARE @string AS NVARCHAR(4000)

SELECT    @string = 'BCP "exec YourDatabase.dbo.YourSproc" QUERYOUT c:\data.csv -c -T -t'

exec master.dbo.xp_cmdshell @string

answered Feb 1, 2013 at 21:42

Alan Fisher

2,0554 gold badges42 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Loganj99 Over a year ago

Works good, but you have to add a comma after the '-t'. Otherwise it will just put all of the columns in the same row in excel.

user596075 · Accepted Answer · 2011-10-17 12:24:17Z

0

The only way I really see this possible is, in the stored procedure, have a call to xp_cmdshell to execute bcp with the parameters you are looking for. Not sure of any other way to do that.

answered Oct 17, 2011 at 12:24

user596075

Collectives™ on Stack Overflow

Creating a CSV file in a SQL Server stored procedure

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related