Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

Bug report: Temporal tables in SQL Server, not possible to create new records

I cannot seem to create new records in a temporal table in SQL Server 2016, since the start_date and end_date fields are seen as required, whereas they are system generated and cannot be included in a Patch statement.


It is possible to update records, however.


Has anyone found a work-around?


Hi Meneghino,


Many thanks. I will suggest other customers who have the same request to vote your idea at here.


Best regards,
Mabel Mao


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (54,878)