SQL+CE 源代码

use student_class select 2006-sage as birthday from Student where sname='刘晨'

use student_class select student.* from student,sc where student.sclass=sc.sclass and student.sno=sc.sno and cno='2' and grad…

select sname, grade from sc,student where cno=2 and student.sno=sc.sno and student.sclass=sc.sclass and student.sno in(selec…

use student_class select * from Student where sname like'刘%'

use student_class select * from student where sclass='2'and ssex='Ů'

use student_class create table Student ( sclass varchar(2),--班级 sno varchar(2),--学号 sname varchar(10) not null,--姓名 ssex var…

use student_class select sno,sname from student where sclass='1'

create table Course (cno varchar(3),--课号 cname varchar(20) not null,--课名 cpno varchar(3),--先行课 ccredit real ,--学分 primary key…

use student_class select distinct student.sclass ,student.sno from student ,sc x,sc y where student.sclass=x.sclass and student…