如何在SQL Server中删除一条记录后重新排序记录(SortOrder列)?

I was wondering what the most efficient way is to reorder my records after I delete a record. Basically I have something like (ItemID, SortOrder). So when I delete an item, the SortOrder column will no longer be incremental. I want to re number sort order so that the numbers are incremental again.I was wondering what the most efficient way is