Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retro-fit an identity column
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Retro-fit an identity column
Divers
Thread ID:
00418151
Message ID:
00418151
Vues:
53
If the a large VFP data with compound key have already been upsized and now resides in MSSQL but I want to create a new Identity column to use as primary key how can I assign the values for existing records? In VFP I could issue something like:

REPLACE ALL newcolumn WITH RECNO()
It's "my" world. You're just living in it.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform