create table [user]
(
id identity(1,1),
name varchar(20),
password varchar(20)
) //id identity(1,1) 数据类型呢???create table [user]
(
id int identity(1,1),
name varchar(20),
password varchar(20)
) 就可以了
(
id identity(1,1),
name varchar(20),
password varchar(20)
) //id identity(1,1) 数据类型呢???create table [user]
(
id int identity(1,1),
name varchar(20),
password varchar(20)
) 就可以了
不填写
id默认的数据类型不是int哦
(
id int identity(1,1), --这里int
name varchar(20),
password varchar(20)
)insert into [user](name,password)
values('aasdf','aasdf')select * from [user]
/*
id name password
----------- -------------------- --------------------
1 aasdf aasdf(所影响的行数为 1 行)
*/drop table [user]