If we can't deprecate this synonym for ROWVERSION, then we need to get better at telling the story that this data type does not store any date or time information. I am constantly coming across users who do this:CREATE TABLE dbo.foo( bar INT, [timestamp] TIMESTAMP);And then expect to do:INSERT dbo.foo SELECT 1, GETDATE();This unfortunately named synonym needs to be phased out, because users are not getting any smarter about it.
Category
Proposed Solution
Benefits
Other Benefits
Please wait...