1 create database data0425
2 go
3 use data0425
4 go
5 create table student
6 (
7 code varchar(50) primary key,
8 name varchar(50),
9 sex bit,
10 birthday datetime,
11 score decimal(10,2),
12 )
13
14 insert into student values('101','张三','1','1991-03-08','81')
15 insert into student values('102','李四','0','1992-03-08','82')
16 insert into student values('103','王五','1','1993-03-08','83')
17 insert into student values('104','赵六','1','1994-03-08','84')
18 insert into student values('105','冯七','0','1995-03-08','85')
19
20 select * from student
21
22 /*修改*/
23 select * from student where code='102'
24
25 update student set score=98.23 where code='102'
