How will you differentiate between Timestamp and Datetime SQL Server?

Question

I was thinking that both formats could store date + time. Then what is the difference between them?

Answer 1

The official documentation says that timestamp is a synonym for rowversion - it gets generated automatically and assured to be a unique datetime. It's normally a data type that handles dates and times and can be client-specified on insert etc.

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.