Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.ms-sqlserver | Notorious Rube Goldberg contraption | 19,505 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 17,801 of 19,505 |
| Plamen Ratchev to All |
| Re: extracting a query into a text file |
| 03 May 10 11:07:19 |
050b49cd From: Plamen@SQLStudio.com There is not a straight forward method to extract data into text file in SQL Server. Especially if you want to do this from T-SQL and avoid using xp_cmdshell. You can build something using CLR, here is one example: http://www.mssqltips.com/tip.asp?tip=1662 -- Plamen Ratchev http://www.SQLStudio.com --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca