bcp out sort order

• Green Armchair

  Hall of Fame

  Points: 3561

  More actions

  October 23, 2003 at 9:01 am

  #162669

  Hi

  What order does bcp output its data? e.g.

  bcp <table> out <filename> -T -S. -N

  Is the order predictable, or would I have to use queryout to dictate the order? I'd like to output it in clustered index order so that its faster to load back in.

  Thanks

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 23, 2003 at 11:11 am

  #479341

  Use "queryout" rather than "out" with a query ordering by the clustered index. Then, if you don't change the indexed values, you can load using the ORDER hint.

  
  
  bcp "SELECT * FROM <table> ORDER BY <clustered index column(s)>" queryout <filename> -T -N

  --Jonathan

  
  
  --Jonathan