Txt file

[gust1480]

Can somebody pls help me how to make a query wherein the result should be in a txt file? I need the sql script on this. Tnx!

 

[dhulbert]

Only way I can see to do it would be to create a DTS package that runs the query creates a temp table with the results in and then exports the data to a text file for you.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[SQLDenis]

one way is to use BCP

run this
exec master..xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout c:\bcptest.txt -c -t ,'


this will create a text file on your C drive named bcptest.txt, the output is delimited by a comma

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dhulbert]

Denis

Thanx I've never used BCP so I'll have a look into it and see if I cna make us eof it on other things.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)