34,590
社区成员
发帖
与我相关
我的任务
分享
create table aaa
( Id int identity(1,1),
No int default(isnull(scope_identity(),0)+1),
Name varchar(20)
)
insert into aaa(Name) values('a')
select * from aaa
/*
Id No Name
----------- ----------- --------------------
1 1 a
(1 row(s) affected)
*/
create table bbbl11
( Id int identity(1,1),
No AS ID+1 PERSISTED PRIMARY KEY,
Name varchar(20)
)
insert into bbbl11(Name) values('a')
insert into bbbl11(Name) values('a')
select * from dbo.bbbl11
create table bbb
( Id int identity(1,1),
No int default(isnull(scope_identity(),0)+1) PRIMARY KEY,
Name varchar(20)
insert into bbb(Name) values('a')
insert into bbb(Name) values('a')
select * from bbb
create table aaa
( Id int identity(1,1),
rno as id primary key,
Name varchar(20)
)
insert into aaa(Name) values('a')
insert into aaa(Name) values('a')
insert into aaa(Name) values('a')
select * from aaa
create table aaa
( Id int identity(1,1),
No int default(isnull(scope_identity(),0)+1),
Name varchar(20)
)
create table aaa
( Id int identity(1,1),
rno as id,
Name varchar(20)
)
insert into aaa(Name) values('a')
insert into aaa(Name) values('a')
insert into aaa(Name) values('a')
select * from aaa
drop table aaa