You can use bcp to extract data from a partition, and you can select data out of a partition if you specify a where clause that includes only that partition's key values. You can load data directly into a partition with bcp.
You can not use select to retrieve data from a single partition by specifying the partition name.
You can move data between partitions by changing the partition-key values. If you update the column used in a partition key to a value that is in a different partition, the row is physically relocated to the other partition. Adaptive Server does this using deferred update, in which the existing row is “deleted” from the current partition, and “inserted” into the new partition. For example, if you partition a table with a state column, updating the column from NY to CA changes the partition. A deferred update consisting of the removal of the NY row and the insertion of the deleted row is recorded in the transaction log –the same as any other deferred update operation.
