作业

create database School on primary
(
name='TestSchool',
size=10mb,
filename='D:\数据\School.mdf',
filegrowth=10,
maxsize=100mb
)
log on
(
name='School',
size=10mb,
filename='D:\数据\School_log.ldf'
)


use School


create table TblClass
(
ClassId int identity(1,1) primary key,
ClassName nvarchar(10) not null,
ClassDesc nvarchar(50)
)




insert into TblClass (ClassName,ClassDesc) values ('高一二班','二等班')


--{
insert into TblClass
select '高一三班','三等班' union
select '高二一班','一等班' union
select '高二二班','二等班' union
select '高二三班','三等班'
--}




create table TblStudent
(
tsId int identity(1,1) primary key,--id
tsName nvarchar(10) not null,
tsGender bit not null,
tsAddress nvarchar(200),
tsPhone varchar(50),
tsAge int,
tsBirthday datetime,
tsCardId varchar(15),
tsClassId int
)
alter table TblStudent alter column tsCardId varchar(18);




insert into TblStudent (tsName,tsGender,tsAddress,tsPhone,tsAge,tsBirthday,tsCardId,tsClassId) values (N'张三',1,N'河北省','15012123224',20,'1983-5-6','123456789012345678',1)


--{
insert into TblStudent
select N'李四',1,N'河北省','15012134222',19,'1982-8-6','123456789012312324',1 union
select N'王五',1,N'河北省','15032523333',18,'1989-5-19','123456789012345672',1 union
select N'赵六',1,N'河北省','15043573644',22,'1985-12-6','123456789012345673',4 union
select N'韩梅梅',1,N'河北省','1505234555',22,'1981-3-6','123456789012345674',2 union
select N'李磊',1,N'河北省','15062736666',50,'1954-1-16','123456789012345676',3 union
select N'达芬奇',1,N'河北省','1507325777',50,'1982-8-8','12345678901234565',5