摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--课程表create table sub( sub_id int identity Primary key,--课程编号 sub_name varchar(100) not null,--课程名... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--设备丢失故障表. CREATE TABLE lost( lost_id int IDENTITY PRIMARY KEY,--编号 Computer_id int NOT NULL,... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--预约设备信息create table reserve ( reserve_id int identity Primary KEY,--编号 Computer_id int not null,-... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--使用日志create table useInfo( useInfo_id int identity Primary KEY,--编号 Computer_id int not null,--设备编号... 阅读全文
摘要:
--9、上机设置表create table online( online_id int identity Primary key,--设置编号 online_value varchar(4) not null,--上机价格 online_overtake1 varchar(4) not null,--超过多长时间按一个小时计算 online_overtake2 varchar(4) not... 阅读全文
摘要:
--8、上课时间对应表create table attend( attend_id int identity Primary key,--上课时间编号 time1 varchar(10) not null,--起始时间 time2 VARCHAR(10) NOT NULL,--结束时间 num int not null --节次 1,2,3,4,5,6) 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--7、学期表create table term( term_id int identity Primary key,--学期编号 term_name varchar(10) not null,--学... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--6、专业信息表create table Specialized( Specialized_id int identity Primary key,--专业编号 Specialized_name... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--5、设备状态管理create table Condition( Condition_id int Identity Primary Key,--状态编号 Condition_name varc... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--4、实验室设备管理create table Computer( Computer_id int Identity Primary key,--设备编号 Computer_name varchar(... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--3、实验室管理create table room( room_id int Identity Primary key,--实验室编号 room_name varchar(50) not null,... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--2、学生信息create table student( student_num int Primary key,--学号 student_name char(50) not null,--姓名... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--1、用户信息create table users( users_id Int Identity Primary key,--用户编号 users_name varchar(50) not null... 阅读全文
摘要:
1、创建数据库 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1User master2go3Create DataBase lab4On5 PRIMARY(NAME=lab_data,FILENAME='E:\我的文档\Visual Studi... 阅读全文