Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is timestamp_column?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01278358
Message ID:
01278360
Vues:
19
>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
Semper ubi sub ubi.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform