select TO file

Question

select TO file

ckmoied

Ten Centuries

Points: 1092
More actions
December 3, 2007 at 4:47 am

#377281

How can take output of select statement to a file.
say
select * from MyTable TO c:\MyFile.txt

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

duncanwill SSC Veteran Points: 298 More actions · Answer 1

The easiest way is to use a DTS which in itself is a fairly large area of knowledge but the task you want should be fairly straight forward. Lots of resources are available... try this as a starting point:

http://www.devarticles.com/c/a/ASP/Creating-DTS-Packages-With-SQL-Server-2000/

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 2

EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -Q "EXEC sp_who2" -o "E:\output.txt"'

Or

You can use DTS

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Another very useful thing is BCP utility.

Look in BOL for complete description.

_____________
Code for TallyGenerator