Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is timestamp_column?
Message
From
31/12/2007 09:37:26
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01278358
Message ID:
01278600
Views:
28
>>>>It looks like each one of the tables of my SQl Server database has a column timestamp_column of type timestamp. I don't remember adding this column. How could it have gotten there?
>>>>
>>>>Also, the Insert into a table fails pointing that Default should be used when inserting to timestamp_column. How do you do it?
>>>>
>>>>Thank you in advance.
>>>>
>>>>UPDATE: I found that not all tables have this column but a lot of them. Could this column been added by VFP wizard that converted VFP database to SQL Server? Is it then ok to delete this column?
>>>
>>>Here is a link to the M$ docs : http://msdn2.microsoft.com/en-us/library/aa260631(SQL.80).aspx
>>>The timestamp column is updated automatically on insert and update. This data type is usually used to version stamp a record. I am unsure how this collumn got added if you didn't do it.
>>>
>>>Einar
>>
>>Correction. The link is not dead but when I simply click on it it forwards me to another link. But if I type the URL manually, I find the article. Thank you.
>
>You are welcome. Very odd that the link didn't open the correct page when clicked (it did the same thing for me). I am glad you tried to paste it into the address bar.

The .aspx extension was not included in the hyperlink.
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform