给表中的每个值加一...

To add one to every value in the table...

UPDATE myTable
SET ID = ID + 1

要创建一个比前一个最高值多一个的新值(通常)，请使用带有 IDENTITY 的 列

To create a new value, one more then the previous highest (usually), use a column with IDENTITY