Dealing With Dates: Manipulating Dates (SQL Server)

Posted on
3,559 Points
2 Endorsements
Last Modified:
Experience Level: Beginner
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Author:Steve Wales
Migrating data tables from MS Access to SQL Server is not for faint-hearted people, you have to draw all your programming knowledge to a higher assumed expertise level. Be prepared to sort out programming issues at a higher level.
I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month