Update a table column with a sequence number v3

-- Create and populate a temporary table:
CREATE TABLE #TableA
(
SeqId int,
FirstName varchar(50),
LastName varchar(50)
)

DECLARE @Counter int
SET @Counter = 0
WHILE @Counter < 1000
BEGIN
INSERT INTO #TableA VALUES (Null, 'abc', 'xyz')
SET @Counter = @Counter + 1
END


-- Update the sequence number:
DECLARE @SeqId int
SET @SeqId = 0

UPDATE
#TableA
SET
@SeqId = SeqId = @SeqId + 1


-- Return the data and remove the table:
SELECT * FROM #TableA
DROP TABLE #TableA