Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is SQL Server Timestamp deprecated and what to use in replacement

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.

like image 730
johnc Avatar asked Sep 15 '09 01:09

johnc


1 Answers

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.

like image 93
Ben M Avatar answered Oct 25 '22 02:10

Ben M