I need to be able to dump all the records of a SQL Server
database into a flat text file but I just want to dumb
For example, my database contains 10 millions records
and its structure has 10 fields. I want to dump these 10
millions records into a flat file but only want to keep
3 fields out of 10.
Is there a fast way to do it without having to write a VB
application going through ADO/ODBC to create that flat file ?
The reason I'm asking is that maybe SQL Server already has
some built-in features to do such a thing without having to
write a VB or VC component to do it.
Note that I'm not asking how to write a VB component to do it
because I know how to do it, I just want to know if there is
a faster, simpler way to do it.
Please reply to my email personally since it's much faster
for me to locate the answer.