Skip to content

Instantly share code, notes, and snippets.

@arman-hpp
Created December 26, 2015 03:33
Show Gist options
  • Save arman-hpp/b2db34932ce288849aea to your computer and use it in GitHub Desktop.
Save arman-hpp/b2db34932ce288849aea to your computer and use it in GitHub Desktop.
USE [Valieasr_336_17]
GO
WITH RowNumbers AS
(
select *,
RowNum = 10000000 + row_number() OVER ( order by Id )
from [Person].[Persons]
)
UPDATE RowNumbers
SET [PersonNo] = RowNum
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment