Home Forums SQL Server 2008 T-SQL (SS2K8) Code to populate aritficial key RE: Code to populate aritficial key
Ken McKelvey
SSCoach
Points: 18768
More actions
January 26, 2016 at 2:22 pm
#1854556
Try something like:
WITH RNs
AS
(
SELECT *
,-ROW_NUMBER() OVER (ORDER BY <WhatEverYouWant>) AS rn
FROM YourTable
WHERE YourPK IS NULL
)
UPDATE RNs
SET YourPK = rn;