Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is timestamp_column?
Message
De
29/12/2007 16:49:33
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
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:
01278369
Vues:
16
>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?

Dmitry,
I don't know how you might have gotten it, maybe wizard is adding but I don't use wizards.

A timestamp column is a column used for concurrency and is a misnomer (have noting to do with time). Other name is more clear "rowversion". You don't update it, it is updated automatically and set to a database width unique big integer value with each update. In pseudocode it is used like:

if primarykey = primarykeyValueIHave and timestamp = timeStampValueIHave
then it is the record I retrieved and nobody else tampered with it

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform