SET IDENTITY_INSERT products ON
insert into products(pid,pname) values (1,‘pname1‘);
insert into products(pid,pname) values (2,‘pname2‘);
insert into products(pid,pname) values (3,‘pname3‘);
SET IDENTITY_INSERT products OFF
这样就能插入标识列
原文：http://www.cnblogs.com/hbhzz/p/4010689.html