August 21, 2008 at 10:10 am
Hi all,
We haver a table, where one of the columns is in DateStamp datatype. But the data contained in the table has 0x000000000170C7DB entered for example. This table is used/generated by importing data from another source. Is this just am import error? formating error etc?
August 21, 2008 at 10:46 am
the timestamp column is a column type that has system generated binary data in it.
typically used for replication.
August 21, 2008 at 11:04 am
Microsoft misnamed the "timestamp" data type. It's actually a binary row version number, and is unique per-database. It updates every time you update the row.
It's got uses, in replication or audit logs, but it's not a timestamp, and Microsoft has stated repeatedly that they misnamed it and it should be called rowversion.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply