T-SQL

• sunandas

  Old Hand

  Points: 357

  More actions

  March 16, 2008 at 10:23 pm

  #71717

  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.

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  March 16, 2008 at 11:21 pm

  #790212

  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

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Anipaul

  SSC-Insane

  Points: 24681

  More actions

  March 16, 2008 at 11:51 pm

  #790219

  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