Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is timestamp_column?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01278358
Message ID:
01278362
Views:
12
>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform