Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server timestamp use
Message
De
04/10/1999 17:58:19
 
 
À
04/10/1999 17:11:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00272478
Message ID:
00272488
Vues:
41
SQL Server updates the timestamp column of a row whenever the information in the row is changed. It'll have no effects on performance unless you're accessing the timestamp column within your queries. Many developers use the timestamp to implementing optimistic locking. If the timestamp has a different value when you go to write the new data then it had when you read the data, someone else has made a change.

How are you trying to copy the tables? You can't explicitly place a value into a timestamp column. Try changing you copy routine to only place values into the columns that aren't timestamps (and identities).

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform