6.21 ADO添加及查询 SQL

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‘

 

6.21 ADO添加及查询 SQL

标签：