Insertar valor autoincrementado en SQL

DECLARE @counter int
SET @counter = 0
UPDATE cola
SET IdCola = @counter, @counter = @counter + 1