SQL Server will take care of updating the datetime columns (which you can call whatever you want) and generating the history table. You can, if you wish, explicitly create your own history table, ...

With (Memory_Optimized = On; By default, setting the Memory_Optimized option creates a durable table. If you're willing to lose all of your data when SQL Server shuts down you can add a Durability ...

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.