自动增加ID出现不连续可能出现的问题
作者:大鹏 发布于:2009-4-24 12:22 Friday
分类:Asp.Net 2.0
标签: 服务器 sqlserver2005 asp databasemssql-2005
[code]
create table aaa (
id int identity(1,1),
names nvarchar(100),
primary key (id)
)
Go
begin transaction test
insert into aaa (names) values('aaa');
insert into aaa (names) values('aaa');
insert into aaa (names) values('aaa');
rollback transaction test
Go
insert into aaa (names) values('aaa');
select * from aaa
Go
[/code]