- MT platform: All
This scalar TSQL function returns a computed age between two dates, shown in whole months and days (0M 0D), typically used for infants.
This stored procedure is designed to help document programming objects (stored procedures and user-defined functions) so you can catalog your code and understand which MEDITECH Data Repository live tables and columns your code refers to. It will help plan for DR database schema changes and major version upgrades.
This TSQL query is useful to compare DR database schemas between test and live databases. This script produces a detailed list of changes by comparing your existing release in live against a newer version in test, and shows changed items by category (new tables, new columns, removed columns, datatype changes, etc.).