Incidentally, if I was using SQL Server 2005 (or any database that supports XML as a colunmn-type and supports XPath/XQuery) I would consider creating an XML Schema that support international ...

There is an important distinction that comes up here between Access and SQL Server that is critical to your table design and future expandability. Access does not comply with the ANSI SQL ...

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven’t ...