create table Role( RoleID int identity primary key )
create table Role( RoleID int identity(1, 1) not null primary key )
create table Role( RoleID int identity primary key , Rolestr varchar(10) )insert into role(rolestr) values('A') insert into role(rolestr) values('B') insert into role(rolestr) values('C') insert into role(rolestr) values('D') insert into role(rolestr) values('E') select * from roledrop table role/* RoleID Rolestr ----------- ---------- 1 A 2 B 3 C 4 D 5 E(所影响的行数为 5 行) */
create table Role( RoleID int identity(1,1) primary key )
create table #Role( RoleID int identity(1,1) primary key )
RoleID int identity primary key
)
RoleID int identity(1, 1) not null primary key
)
RoleID int identity primary key ,
Rolestr varchar(10)
)insert into role(rolestr) values('A')
insert into role(rolestr) values('B')
insert into role(rolestr) values('C')
insert into role(rolestr) values('D')
insert into role(rolestr) values('E') select * from roledrop table role/*
RoleID Rolestr
----------- ----------
1 A
2 B
3 C
4 D
5 E(所影响的行数为 5 行)
*/
RoleID int identity(1,1) primary key
)
RoleID int identity(1,1) primary key )