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.