然后选择scope_identity（）生成重复的行

CREATE TABLE [schema].[table] (
  [column1] int IDENTITY NOT NULL,
  [column2] int NULL,
  [column3] int NULL,
  PRIMARY KEY CLUSTERED ([column1])
);
INSERT INTO schema.table (column2,column3) VALUES (1,1);
SELECT scope_identity();
CREATE TABLE [schema].[table] (
  [column1] int