Post reply

bcp out sort order

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply