MSSQL如何向一个自增列中插入值

sql分享 

--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