【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“book_1_data.sql”一文,供大家参考学习!
insert branch values('999','其它')
insert branch values('K','高雄')
insert branch values('S','新竹')
insert branch values('T','台北')
insert classroom_area values('999','未开发区域','999')
insert classroom_area values('K1','高雄','K')
insert classroom_area values('S1','新竹','S')
insert classroom_area values('T1','台北复北B1','T')
insert classroom_area values('T2','台北复北14F','T')
insert classroom_area values('T3','台北复北12F ','999')
insert classroom values('K','k',40,'T3')
insert classroom values('M','新竹',40,'S1')
insert classroom values('N','新竹',40,'S1')
insert classroom values('O','新竹',40,'S1')
insert classroom values('P','新竹',40,'S1')
insert classroom values('Q','',40,'999')
insert classroom values('R','',40,'999')
insert classroom values('S','',40,'999')
insert classroom values('T','',40,'999')
insert classroom values('U','',40,'999')
insert classroom values('V','',40,'999')
insert classroom values('W','高雄',40,'K1')
insert classroom values('X','高雄',40,'K1')
insert classroom values('Y','高雄',40,'K1')
insert classroom values('Z','高雄',40,'K1')
insert course_catalog values('001','Microsoft')
insert course_catalog values('002','CISCO')
insert course_catalog values('003','Oracle')
insert course_catalog values('004','Redhat')
insert course_catalog values('005','Sun')
insert course_catalog values('006','Trend')
insert course values('100','电子商务XML实作与运用','电子商务XML','电子商务XML实作与运用',14,7200,'1','001')
insert course values('101','电子商务ASP程式设计实务','ASP','电子商务ASP程式设计实务',28,9600,'1','001')
insert course values('1013','VB 6.0 应用程式开发','MVB6','Mastering Microsoft Visual Basic 6 Development',28,12000,'1','001')
insert course values('1016','VB 6.0 企业开发解决方案','MVBE','Mastering Enterprise Development Using Microsoft Visual Basic 6',28,12000,'1','001')
insert course values('1017','动态网站开发进阶','MVID','Mastering Web Application Development Using Microsoft Visual InterDev 6',28,12000,'1','001')
insert course values('102','微软企业对企业B2C商业解决方案Microsoft Biz Talk Server Workshop','Biz','Microsoft Biz Talk Server Workshop',12,8400,'1','001')
insert course values('1111','Exchange 2000 Server 之系统建置与规划训练课程','EX001','MS Exchange 2000 Server',28,12000,'1','001')
insert course values('1125','建置网站管理伺服系统','SITE','Implementing Microsoft Site Server 3.0',21,9600,'1','001')
insert course values('113','Windows DNA 2000电子商务解决
方案与COM+元件设计','COM+A','Windows DNA 2000电子商务解决方案与COM+元件设计',14,8400,'1','001')
insert course values('114','SQL Server7.0资料库管理及设计实务','SQL A&I','SQL Server7.0资料库管理及设计实务',28,9600,'1','001')
insert course values('115','电子商务基础概论','电子商务基础概论','电子商务基础概论',28,9600,'1','001')
insert course values('1298','分散式应用程式开发架构','MVS','Mastering Distributed Applications Design Using Microsoft Visual Studio',21,9600,'1','001')
insert course values('1301','Office 2000
VBA','VBA(2000)','Office 2000 VBA',28,12000,'1','001')
insert course values('1303','VB6.0 程式设计基础','MVBF6','Mastering Microsoft Visual Basic 6 Fundamentals',28,12000,'1','001')
insert course values('1560','Windows NT4.0升级到Windows2000技术支援','1560','Upgrading Support Skills form Microsoft Windows NT Server 4.0 to Windows 2000',35,15000,'1','001')
insert course values('1561','Windows2000的目录服务架构设计','1561','Designing a Microsoft Windows 2000 Directory Services Infrastructure',14,7200,'1','001')
insert course values('1562','设计 Windows 2000的网路服务架构','1562','Designing a Microsoft Windows 2000 Networking Services Infrastructure',28,12000,'1','001')
insert course values('1572','Exchange Server 2000之系统建置与规划','1572','Implementing and Managing Microsoft Exchange 2000',28,12000,'1','001')
insert course values('1588','Site Server电子商店B2C高阶设计技巧','B2C','Site Server电子商店B2C高阶设计技巧',14,9600,'1','001')
insert course values('1610','Site Server电子商务B2B企业供应链进阶整合技术','B2B','Site Server电子商务B2B企业供应链进阶整合技术',14,9600,'1','001')
insert course values('1904','Building Knowledge Management Solution With Microsoft Office 2000','1904','Building Knowledge Management Solution With Microsoft Office 2000 ',14,8400,'1','001')
insert course values('1905','XML电子商务网站应用程式高阶
设计','XML','Building XML-Based Web Application',28,12000,'1','001')
insert course values('1907','Windows 2000 Com+ 分散式应用程式设计实物 ','1907','Building Distributed Appli