The T-SQL MSDN page states
The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Does this mean to suggest that the SQL Server Timestamp data type is also deprecated as well? If so, what should be used to replace it, as the SQL Server DateTime data type is not granular enough to ensure high transactional records can be stamped with a unique value.
That same page says to use rowversion
instead of timestamp
. The deprecation is the syntax, not the underlying mechanism. Can you imagine them removing support for such a widely-used feature? Fugghedaboudit.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With