how can i export from sql sever table data to another text or csv file thorugh sql server stored procedure..import is working fine...
can u give me a solution ..
Thanks and Regards
ArulThere are ways to run though the File I/O in a stored procedure, but do you really want your sql server to have that type of file security abilities?
I'd suggest either doing through code, or running a loop that sets a file to become that text file. And blob that.
there's also DTS Capabilities that you can use.
Books Online is your best friend. Remember that.
No comments:
Post a Comment