1、create table Student(
Sno int primary key identity(1,1) not null,
Sname varchar(50) null,
Ssex varchar(3) null,
Sage varchar(50) null,
Sdept varchar(50) null)2、insert into Student(Sname,Ssex,Sage,Sdept) values (张三,女,20, 计算机)3、select * from Student where Sdept = '计算机'4、select Sname, Sa
|