>Can I use the PRINT command to redirect the output to a file? Additive? I need to create a comma delimited file from some variables as I loop through.
>
>Also, as an aside, the SQL Management Studio help sucks. I looked up PRINT, which told me next to nothing. Then I asked it how to print query results and it proceeded to instruct me on how to use the copy/paste. Is there a really decent online resource for the commands, etc? I found stuff, but nothing that was very useful.
Check the whole thread
Re: SQL syntax for StrToFile Thread #
999056 Message #
999076 SQL Server is the Database engine, it's not a language oriented towards other tasks, such as VFP or C#, for example.
If it's not broken, fix it until it is.
My Blog