Deprecate TIMESTAMP (the keyword, not ROWVERSION itself) - by AaronBertrand

Status : 

 


42
0
Sign in
to vote
ID 274333 Comments
Status Active Workarounds
Type Suggestion Repros 3
Opened 4/27/2007 1:56:42 PM
Access Restriction Public

Description

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.
Sign in to post a comment.
Posted by swasheck on 8/14/2014 at 3:56 PM
Wow 2007. That's a lot of looking.
Posted by Microsoft on 12/13/2007 at 4:39 PM
Dear Aaron

Thanks for your feedback. We agree that the original naming of this type was unfortunate (and we can blame our predecessors ;-)). Especially since the name is used in the SQL standard for date/time datatypes.

We are going to look into how we can address this issue in a backwards-compatible way in the upcoming releases.

Please keep the votes coming.

Thanks
Michael