数据库样本.docVIP

--------------------数据库初始化工作----------------------- set nocount on set dateformat mdy go use master go if exists (select * from sysdatabases where name=sports) drop database sports go --------------------数据库的建立----------------------------- CREATE database sports ON primary (NAME = sports_data, FILENAME = d:\database\sports_data.MDF , SIZE = 2, FILEGROWTH =1, MAXSIZE=10) LOG ON (NAME = sports_Log, FILENAME = d:\database\sports_Log.LDF , SIZE = 1, FILEGROWTH = 1, MAXSIZE=5) GO ------------------表的建立--------------------------------- use sports if exists (select * from sysobjects where name=match_sort) drop table dbo.match_sort go print drop table match_sort print create match_sort GO /*赛事类别表*/ create table match_sort( sort_no char(4) not null, /*类别编号*/ sort_name char(10) not null, /*类别名称*/ primary key(sort_no) ) go ----------------------插入数据----------------------------------- insert into match_sort values(a001,田赛) insert into match_sort values(a002,径赛) insert into match_sort values(a003,集体项目) ----------------------------------------------------------------- if exists (select * from sysobjects where name=match_item) drop table dbo.match_item go print drop table match_item print create match_item GO /*比赛项目表*/ create table match_item( item_no char(4) not null primary key, /*项目编号*/ check(item_no like I[0-9][0-9][0-9]), item_name char(20) not null, /*项目名称*/ sort_no char(4) not null, /*类别编号*/ qty smallint not null, /*每个项目参赛人（队）数*/ start_time datetime not null, /*比赛开始时间*/ finish_time datetime null, /*比赛结束时间*/ foreign key(sort_no) references match_sort(sort_no), constraint ck_qty check (qty=8 and qty