长途汽车信息管理系统 课程设计报告

询分析器的SQL编辑窗体中,并运行可得创建的Busline表及其属性如图1-6:Р图1-6 Busline表格属性Р往表中加数据语句如下:Рinsert into BuslineРvalues('淮南','合肥','8:00','50');Рinsert into BuslineРvalues('淮南','蚌埠','8:30','59');Рinsert into BuslineРvalues('淮南','阜阳','7:30','60');Рinsert into BuslineРvalues('淮南','宿州','8:10','65');Рinsert into BuslineРvalues('淮南','芜湖','7:00','70');Рinsert into BuslineРvalues('淮南','安庆','9:00','71');Рinsert into BuslineРvalues('淮南','桐城','9:50','78');Рinsert into BuslineРvalues('淮南','亳州','8:50','80');Рinsert into BuslineРvalues('淮南','黄山','9:00','100');Р由以上可得一个表名为”Busline”的数据表就建成了如图1-7:Р2. 创建汽车表Р用Microsoft SQL 2000 Server数据库系统的Transact-SQL语句定义创建这个表,程序如下:Рcreate table BusР(РType char(20),Р Maxpassenger smallint,Р Turn char (20) primary key,Р Remainder smallint,Р );Р将代码写入SQL查询分析器的SQL编辑窗体中,并运行可得数据空表如图1-8所示:Р创建的Bus表及其属性如下: