Friday, December 15, 2017

SQL - update column with sequence number starting from 1


DECLARE @id INT;
SET @id = 0
UPDATE x SET @id = [ItemNo] = @id + 1