sql 自增长id 也能插入数据

CREATE TABLE #test
(
 id    INT IDENTITY(1, 1),
 NAME  VARCHAR(100)
)
GO

SET IDENTITY_INSERT #test ON

INSERT INTO #test(id,name)
VALUES
  (
    1,
    '111'
  )
SET IDENTITY_INSERT #test OFF

select * from #test