TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Performing Data Changes Audit Using Temporal Table
Jim Lorinser
Aug 30 2018
Resource
0
0
2.8
k
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
expand
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using a normal table, you can retrieve current data; while using a system-versioned temporal table, you can retrieve data which was deleted or updated in the past. To do that, a temporal table will create a history table. The history table will store old data with “
start_time
” and “
end_time
”. Which indicates a time period for which the record was active.
Learn More >>
SQL Server
MSSQL
Performance
Temporal Table