代替
+ 1，添加行号。我还修复了您的WHERe子句中的错误（应该是
GroupID =，而不是
ID =）：
INSERT INTO MyTable( [ID] ,[GroupID] ,[Somevalue])( SELECt (SELECT MAX(ID) FROM MyTable) + ROW_NUMBER() OVER (ORDER BY GroupId), @NewGroupID, [Somevalue] FROM MyTable WHERe GroupID = @OriginalGroupID)
