use StudentManageDB
go
insert into Students (StudentName,Gender,Birthday,Age,StudentIdNo ,PhoneNumber,
StudentAddress,ClassId)
values('李小璐','女','1989-01-12',26,120229198901121314, '022-88997766','天津河北区',1) select * from Students use SMDB
go
select StudentName,Gender,Age from Students where age <>22 use StudentManageDB
go
update Students set Gender='男',Age=25 where StudentId=10000
select * from Students use SMDB
go
insert into Students (StudentName,Gender,Birthday,Age,StudentIdNo ,PhoneNumber,
StudentAddress,ClassId,CardNo)
values('李小璐','女','1989-01-12',26,120229198901121314, '022-88997766','天津河北区',1,'')
select * from Students
delete from Students where StudentId=100000
delete from Students where StudentId=100013 select * from ScoreList
delete from ScoreList where StudentId=100000 delete from ScoreList
truncate table Students