Clustered indexes on data-only-locked tables may not return rows in clustered key order if there is no order by clause. Bulk copy is not guaranteed to copy out a table in clustered key order.
Queries on unpartitioned allpages-locked tables with clustered indexes return rows in the clustered key order if the query does not include a sort (that is, if there are no clauses such as order by or distinct). Bulk copy also copies the rows out of allpages-locked tables in clustered key order for both partitioned and unpartitioned tables.
