如何在sql server中插入自增长列的值

SET IDENTITY_INSERT Department ON
INSERT INTO Department (id, name, parentid) VALUES(-1, '无', -1);
SET IDENTITY_INSERT Department OFF

 

OK