March 16, 2008 at 10:23 pm
hi,
i want to know about bcp utilities.Can u please give me the details of it with examples and how can i run it.i cant run it by reading the sql 2000 help.So u please write with all the details.
Also tell me how can i access my data through command prompt.Which tool shall i run so that i can connect to sql server.
regards
Sunanda
Ok.
I just want to know this command of bcp utility will run in command prompt or in query analyzer.
March 16, 2008 at 11:21 pm
It's a fairly large subject... best bet it to look in Books Online under "BCP". Get familiar with the terms and do a bit of studying... try a couple of things. If you can't make it work, come back with the BCP command line you used and the (small) file you tried to import attached to the thread.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 16, 2008 at 11:51 pm
Read these...............
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c07ppcsq.mspx
http://www.paladn.com/bulk-copy-program.htm
http://msdn2.microsoft.com/en-us/library/aa196743(SQL.80).aspx
http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell
http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy