实验二:基础数据如下
create database XSGL
go
use XSGL
go
create table student
(
sno char(8) primary key,...sdept) values(‘95005’, ‘刘云’, ‘女’, 18, ‘CS’)
insert into course(cno, cname,credit,cpno) values(‘1’, ‘数据库...cname,credit,cpno) values(‘4’, ‘操作系统’, 4, ‘6’)
insert into course(cno, cname,credit,cpno) values(‘5’, ‘数据结构...’, 4, ‘7’)
insert into course(cno, cname,credit,cpno) values(‘6’, ‘数据处理’, 3, null)
insert into course...datetime所以不能查到(基本语法如此,birth是datetime的)
select sname+’年龄为’+str(sage)+’岁’ from student—-此处注意多了一个c
select