Unix Technical Forum

copying from a table to a file

This is a discussion on copying from a table to a file within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello Is there a t-sql command to copy data from a table into a file (the opposite of a ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 09-23-2008, 06:11 PM
David Greenberg
 
Posts: n/a
Default copying from a table to a file

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 09-23-2008, 06:11 PM
Plamen Ratchev
 
Posts: n/a
Default Re: copying from a table to a file

You can use the BCP utility:
http://www.sqlteam.com/article/expor...nd-xp_cmdshell
http://msdn.microsoft.com/en-us/libr...3(SQL.80).aspx

--
Plamen Ratchev
http://www.SQLStudio.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads for: copying from a table to a file

Thread Thread Starter Forum Replies Last Post
RE: Copying a table into a file query M.Cressey Ingres 1 04-20-2008 06:20 PM
RE: Copying a table into a file query Mason, Paul Ingres 0 04-20-2008 06:20 PM
Copying a table into a file query P.P.Hughes Ingres 4 04-20-2008 06:20 PM
Copying data from table to table (cloned tables) Fourat Zouari pgsql Novice 7 04-17-2008 11:15 PM
Copying lakhs of Records in a table of 25 columns from text file or Excel Sheet. Pankaj_Jha Oracle Miscellaneous 6 04-08-2008 11:17 AM


All times are GMT. The time now is 05:32 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com