alternate column name for [timestamp] type 1

[msc0tt]

I need to add an auto-updating timestamp column to a vendor-supplied table. Unfortunately, the vendor already has used the [timestamp] name for a custom-column (using the datetime type). If I create a column with a different name, but still use the timestamp type, will SQL still auto-update this field for me?
In other words, when SQL updates a row, does it look for any column with a timestamp type, or specifically for a column named [timestamp] with a timestamp type?
-thanks

 

[NoCoolHandle]

Give it any name you like...

Because it is, i usually call it "rowversion".

i.e. Timestamps dont' equate to a time, they just tell you if your version of the row is the same as the one that is in there now...


Rob

 

[msc0tt]

Thanks NoCool:
Good news indeed. Yes, I knew about the true contents of the field (and misleading name of the data type). In fact, the vendor decided to keep actual datatime info in his 'timestamp' column. 'rowversion' it is!
-Mike