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
- 1楼niyi0318昨天 13:11
- 顶