copying from a table to a file

[David Greenberg]

Hello
Is there a t-sql command to copy data from a table into a file (the
opposite of a bulk insert) ?
(We use sql2000)

Thanks

David Greenberg

[Plamen Ratchev]

Re: copying from a table to a file

You can use the BCP utility:

http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell

http://msdn.microsoft.com/en-us/libr...3(SQL.80).aspx

--
Plamen Ratchev

http://www.SQLStudio.com