tsql : outputting each record to their own text file

Question

is there a simple way to just output each record in a select statement to write to its own file?

for example, if you have the tsql query in sql server 2005,

select top 10 items, names + ':' + address from book

and you ended up with 10 text files with the individual name and addresses in each file.

is there a way to do this without writing an extensive spWriteStringToFile procedure? I'm hoping there is some kind of output setting or something in the select statement.

thanks in advance

OMG Ponies · Accepted Answer · 2010-09-30 19:31:53Z

1

SQL returns the result set first, there's no opportunity in there for writing records to specific files until afterwards.

Being SQL Server 2005, it's possible you could use a SQLCLR (.NET 2.0 code) function in a SQL statement without having to make a separate application.

answered Sep 30, 2010 at 19:31

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

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

Comments

Sage · Accepted Answer · 2010-09-30 19:26:03Z

1

In SSMS, you can do a results to file, but that wouldnt split each record out into its own file. I pretty sure you cannot do this out of the box, so it sounds like you will be rolling your own solution.

answered Sep 30, 2010 at 19:26

Sage

4,9271 gold badge24 silver badges29 bronze badges

Comments

gbn · Accepted Answer · 2010-09-30 19:31:25Z

1

You'd do this in some client, be it Java, VBA or SSIS typically.

answered Sep 30, 2010 at 19:31

gbn

434k84 gold badges602 silver badges690 bronze badges

1 Comment

phill Over a year ago

i was hoping to avoid using some kind of client. it looks like i will have to crank this out in vba.

Collectives™ on Stack Overflow

tsql : outputting each record to their own text file

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related