Once the partitioning is complete, you don't need to rewrite any of your queries;
the table may be accessed as before. However, at the same time partitioning greatly
improves the performance of certain queries.
SQL Partition Manager allows you to perform all possible actions on partitions.
To learn more, please look through the Sliding Window Scenario tutorial.