create database testDB
create table users
(
id int primary key identity(1,1),
uname nvarchar(2000),
jine money,
createtime datetime default getdate()
)
insert into users(uname, jine) values('aa',100)
insert into users(uname, jine) values('bb',200)
insert into users(uname, jine) values('cc',300)
insert into users(uname, jine) values('dd',300) select @@identity --返回自增主键的值
select * from users
