USE tempdb;
GO

BEGIN TRAN

CREATE TABLE test
(
  Id Int NULL
)

INSERT test
VALUES (NULL), (NULL), (NULL)

CREATE SEQUENCE TestSeq
 AS Int
 START WITH 1
 INCREMENT BY 1

ALTER TABLE test ADD CONSTRAINT DF_test_Id DEFAULT (NEXT VALUE FOR TestSeq) FOR Id

UPDATE test SET Id = DEFAULT

SELECT * FROM test

ROLLBACK

WITH T AS (SELECT N=ROW_NUMBER()OVER(ORDER BY OrderField),* FROM TableName)
UPDATE T SET NumberField=N;

WITH T AS (SELECT N=ROW_NUMBER() OVER(ORDER BY _fld223),* FROM [dbo].[_InfoRg222])
UPDATE T SET _fld224=N;

WITH T AS (
SELECT N=ROW_NUMBER() OVER(partition BY _fld223 ORDER BY _fld251),* 
FROM [dbo].[_InfoRg222] 
where SUBSTRING(_fld223,1,1)='0' )
UPDATE T SET _fld224=N;

WITH T AS (
SELECT N=ROW_NUMBER() OVER(ORDER BY _fld223),* 
FROM [dbo].[_InfoRg222] )
UPDATE T SET _fld224=N
where SUBSTRING(_fld223,1,1)='0';

(PARTITION BY _fld223 order by _fld251)