Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create a text file using SP

Author  Topic 

shifis
Posting Yak Master

157 Posts

Posted - 2006-04-17 : 14:12:01
Hi!
I'm trying to create a txt file using the information of my PO lines tables, is there any way to do this using a SP.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-04-17 : 14:20:30
see
http://www.nigelrivett.net/SQLTsql/WriteTextFile.html

bcp tends to be simplest and most flexible.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -