Unanswered: Use ASP to output the BCP data from SQL Server
I am the beginner of the develope.
Now I need to write a ASP to out put the BCP text file.
First I already write the query in Enterprise Manager Stored Procedure. But the next step I don't know how to write it.
I have serach the site for output the BCP, but I am not sure where I should write in.
Thanks so much! Now i tried in Query analyzer and it out the message "copied". It suppose in the drive c has the csv file but I couldn't find it. Is that it will copy to the server drive c but not my PC (client) drive c????