Is there a simple way to write the returned rows of a select statement to a file?
I have found one example where you can write a string to a file in SQL (http://www.simple-talk.com/code/WorkingWithFiles/spWriteStringTofile.txt), but the string max length is 8000 characters, and the table may be larger than that.