update column with incremental value using sql

update column with incremental value using sql

DECLARE @NewID INT;

SET @NewID = 0;

UPDATE myTable
SET @NewID = ID = @NewID + 1