當配合SELECT INTO 或INSERT IDENTITY 函式的行為包含ORDER ...

SET ROWCOUNT 3 SELECT Col1, Col2, ID=IDENTITY (int, 1, 1) INTO NewTable FROM OldTable Order By Col1.

support.microsoft.com