华北电力大学（保定）-《数据库原理及英用》-第7章 代码清单.pdfVIP

createdatabasecjgl_demo--1.创建数据库

on(

name=cjgl_demo,

filename=d:\data\cjgl_demo.mdf,

size=5mb,

maxsize=unlimited,

filegrowth=2mb

)

logon

(

name=cjgl_demo_log,

filename=d:\data\cjgl_demo_log.ldf,

size=2mb,

maxsize=5mb,

filegrowth=10%

)

--2.创建biao

usecjgl_demo--必须写上使用哪个数据库

createtablestudent

(

snochar(8)notnullprimarykey,

snamevarchar(20)notnullunique,

sageintnotnulldefault19,

sdeptchar(4),

ssexchar(2)notnullcheck(ssexin(男,女))default男,

sheightnumeric(4,1),

scpmbit,

srmktext

)

createtablecourse

(

cnochar(6)primarykeynotnull,

cnamevarchar(20)notnullunique,

cxqtinyint,

ccredittinyint

)

createtablesc

(

snochar(8),

cnochar(6),

scorenumeric(4,1)check(score=0andscore=100),

constraintpk_scprimarykey(sno,cno),

constraintfk_sc_studentforeignkey(sno)referencesstudent(sno),

constraintfk_sc_courceforeignkey(cno)referencescourse(cno)

)

insertintostudentvalues(001,赵琳,19,英语,女,170.5,1,null)

insertintostudentvalues(002,杨过,15,古墓,男,175.5,1,null)

insertintostudentvalues(003,小龙女,19,古墓,女,165.5,1,null)

insertintostudentvalues(004,黄蓉,39,丐帮,女,160.5,1,null)

insertintostudentvalues(005,郭靖,40,丐帮,男,170.5,1,null)

insertintostudentvalues(006,郭襄,3,峨眉,女,70.5,1,null)

insertintostudentvalues(007,金轮法王,59,日月,男,170.5,1,null)

insertintostudentvalues(008,李莫愁,27,古墓,女,170.5,1,null)

insertintostudentvalues(009,段誉,19,历史,男,172.5,1,null)

insertintostudentvalues(010,珠儿,19,历史,女,160.5,1,null)

insertintostudentvalues(011,阿紫,15,动力,女,157.5,1,null)

insertintostudentvalues(012,乔峰,30,丐帮,男,182.5,1,null)

insertintostudentvalues(013,虚竹,19,武当,男,173.5,1,null)

insertintocoursevalues(k001,数据库,1,2.5)

inserti