Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retro-fit an identity column
Message
From
19/09/2000 13:22:43
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Retro-fit an identity column
Miscellaneous
Thread ID:
00418151
Message ID:
00418151
Views:
54
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.
Next
Reply
Map
View

Click here to load this message in the networking platform