Trigger SQL server that updates all records in a table

See more:

trigger

I need a trigger in sql server to update all the records of TableX by placing in its column called Index a consecutive integer starting at 1. That is, if a record is inserted or removed from TableX and suppose the table has 100 records . Each record should be left with a consecutive one that goes from 1 to 100. If I delete, for example, the record with index 52, then the trigger must again enumerate the field Index from 1 to 99. I hope to be clear.

What I have tried:

This is my code, but I don't know what to put in the clause "WHERE". How do I let the While know which line I am updating?

Declare @indice int
Declare @Total int

SELECT @ index = 0
SELECT @TotalRegistros = count (*) FROM TableX

WHILE @indice <= @Total
BEGIN
SET @ index = @ index + 1

UPDATE TableX SET Index = @indice WHERE (I don't know what to put here)
END;

Thank you.