--1、create table tablename(id int identity(1,1))go
insert into tablename default values
go
select * from tablenamegodrop table tablename
go--
2、--还用上个表。set identity_insert tablename on
insert tablename(id) select 2
set identity_insert tablename off
本文来自: http://www.52mvc.com/showtopic-632.aspx
insert into tablename default values
go
select * from tablenamegodrop table tablename
go--
2、--还用上个表。set identity_insert tablename on
insert tablename(id) select 2
set identity_insert tablename off
本文来自: http://www.52mvc.com/showtopic-632.aspx