(SQL+Server版)

[{"title":"（84个子文件18.14MB）(SQL+Server版)","children":[{"title":"(SQL+Server版)","children":[{"title":"chapter4","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG4V1.0.ppt <span style='color:#111;'>1.56MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG4-Source","children":[{"title":"第四阶段.sql <span style='color:#111;'>3.48KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP4V1.0.ppt <span style='color:#111;'>2.21MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"SG4-Source","children":[{"title":"示例5：EXISTS子查询.sql <span style='color:#111;'>978B</span>","children":null,"spread":false},{"title":"示例4：NOTIN子查询.sql <span style='color:#111;'>315B</span>","children":null,"spread":false},{"title":"示例3：IN子查询.sql <span style='color:#111;'>385B</span>","children":null,"spread":false},{"title":"示例2：多表子查询.sql <span style='color:#111;'>319B</span>","children":null,"spread":false},{"title":"示例1：什么是子查询.sql <span style='color:#111;'>396B</span>","children":null,"spread":false},{"title":"示例6：综合查询.sql <span style='color:#111;'>2.41KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"理论课作业答案","children":[{"title":"TG4作业答案.sql <span style='color:#111;'>2.75KB</span>","children":null,"spread":false}],"spread":true},{"title":"补充案例","children":[{"title":"NOTEXISTS查询.sql <span style='color:#111;'>111B</span>","children":null,"spread":false},{"title":"人员统计.sql <span style='color:#111;'>949B</span>","children":null,"spread":false},{"title":"In查询.sql <span style='color:#111;'>58B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"chapter2","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG2V1.0.ppt <span style='color:#111;'>2.39MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG2-Source","children":[{"title":"第二阶段.sql <span style='color:#111;'>5.59KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP2V1.0.ppt <span style='color:#111;'>3.98MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"SG2-Source","children":[{"title":"示例7.sql <span style='color:#111;'>197B</span>","children":null,"spread":false},{"title":"示例3.sql <span style='color:#111;'>520B</span>","children":null,"spread":false},{"title":"示例6.sql <span style='color:#111;'>236B</span>","children":null,"spread":false},{"title":"示例4.sql <span style='color:#111;'>187B</span>","children":null,"spread":false},{"title":"示例5.sql <span style='color:#111;'>682B</span>","children":null,"spread":false},{"title":"示例1.sql <span style='color:#111;'>495B</span>","children":null,"spread":false},{"title":"示例2.sql <span style='color:#111;'>713B</span>","children":null,"spread":false},{"title":"示例8.sql <span style='color:#111;'>227B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"理论课作业答案","children":[{"title":"TG2作业答案.sql <span style='color:#111;'>3.51KB</span>","children":null,"spread":false}],"spread":true},{"title":"补充案例","children":[{"title":"创建和修改PRIMARYKEY约束.doc <span style='color:#111;'>25.00KB</span>","children":null,"spread":false},{"title":"用SQL创建数据库登录用户.doc <span style='color:#111;'>34.50KB</span>","children":null,"spread":false},{"title":"约束.sql <span style='color:#111;'>93B</span>","children":null,"spread":false},{"title":"create语句.sql <span style='color:#111;'>236B</span>","children":null,"spread":false}],"spread":true},{"title":"附加题答案","children":[{"title":"建表和约束.sql <span style='color:#111;'>3.27KB</span>","children":null,"spread":false},{"title":"添加帐户和授权.sql <span style='color:#111;'>442B</span>","children":null,"spread":false},{"title":"建库.sql <span style='color:#111;'>737B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"DLC","children":[{"title":"指导学习PPT","children":[{"title":"指导学习V1.0.ppt <span style='color:#111;'>1.97MB</span>","children":null,"spread":false}],"spread":true},{"title":"指导学习答案.sql <span style='color:#111;'>2.54KB</span>","children":null,"spread":false}],"spread":true},{"title":"说明.txt <span style='color:#111;'>99B</span>","children":null,"spread":false},{"title":"chapter6","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG6V1.0.ppt <span style='color:#111;'>2.35MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG6-Source","children":[{"title":"第六阶段.sql <span style='color:#111;'>3.77KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP6V1.0.ppt <span style='color:#111;'>2.59MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"SG6-Source","children":[{"title":"示例6：raiserror语句.sql <span style='color:#111;'>1.76KB</span>","children":null,"spread":false},{"title":"示例5：带输出参数的存储过程.sql <span style='color:#111;'>1.31KB</span>","children":null,"spread":false},{"title":"示例2：xp_cmdshell扩展存储过程.sql <span style='color:#111;'>574B</span>","children":null,"spread":false},{"title":"示例3：不带参数的存储过程.sql <span style='color:#111;'>983B</span>","children":null,"spread":false},{"title":"示例4-1：带参数的存储过程1.sql <span style='color:#111;'>863B</span>","children":null,"spread":false},{"title":"示例1：常用的系统存储过程.sql <span style='color:#111;'>558B</span>","children":null,"spread":false},{"title":"示例4-2：带默认参数的存储过程2.sql <span style='color:#111;'>1.06KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"理论课作业答案","children":[{"title":"TG6作业答案.sql <span style='color:#111;'>2.27KB</span>","children":null,"spread":false}],"spread":true},{"title":"补充案例","children":[{"title":"使用WITHRECOMPILE选项.txt <span style='color:#111;'>644B</span>","children":null,"spread":false},{"title":"使用OUTPUT游标参数.txt <span style='color:#111;'>887B</span>","children":null,"spread":false},{"title":"带通配符的存储过程.txt <span style='color:#111;'>1.08KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"chapter5","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG5V1.0.ppt <span style='color:#111;'>1.60MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG5-Source","children":[{"title":"第五阶段.sql <span style='color:#111;'>2.89KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP5V1.0.ppt <span style='color:#111;'>2.13MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"SG5-Source","children":[{"title":"示例2：如何创建事务.sql <span style='color:#111;'>1.06KB</span>","children":null,"spread":false},{"title":"示例3：创建索引.sql <span style='color:#111;'>547B</span>","children":null,"spread":false},{"title":"示例1：为什么需要事务.sql <span style='color:#111;'>1.12KB</span>","children":null,"spread":false},{"title":"示例4：创建视图.sql <span style='color:#111;'>575B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"理论课作业答案","children":[{"title":"TG5作业答案.sql <span style='color:#111;'>1.01KB</span>","children":null,"spread":false}],"spread":true},{"title":"补充案例","children":[{"title":"index.sql <span style='color:#111;'>79B</span>","children":null,"spread":false},{"title":"view.sql <span style='color:#111;'>227B</span>","children":null,"spread":false},{"title":"trans.sql <span style='color:#111;'>289B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"chapter3","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG3V1.0.ppt <span style='color:#111;'>2.75MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG3-Source","children":[{"title":"第三阶段.sql <span style='color:#111;'>5.07KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP3V1.0.ppt <span style='color:#111;'>4.29MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"SG3-Source","children":[{"title":"变量.sql <span style='color:#111;'>338B</span>","children":null,"spread":false},{"title":"while循环.sql <span style='color:#111;'>438B</span>","children":null,"spread":false},{"title":"if语句.sql <span style='color:#111;'>382B</span>","children":null,"spread":false},{"title":"全局变量和输出语句.sql <span style='color:#111;'>383B</span>","children":null,"spread":false},{"title":"case多分支.sql <span style='color:#111;'>425B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"理论课作业答案","children":[{"title":"TG3作业答案.sql <span style='color:#111;'>794B</span>","children":null,"spread":false}],"spread":true},{"title":"补充案例","children":[{"title":"if语句.sql <span style='color:#111;'>291B</span>","children":null,"spread":false},{"title":"局部变量.sql <span style='color:#111;'>152B</span>","children":null,"spread":false},{"title":"case语句.sql <span style='color:#111;'>1.06KB</span>","children":null,"spread":false},{"title":"Transact.doc <span style='color:#111;'>27.00KB</span>","children":null,"spread":false}],"spread":true},{"title":"附加题答案","children":[{"title":"newT3-3.sql <span style='color:#111;'>344B</span>","children":null,"spread":false},{"title":"newT3-2.sql <span style='color:#111;'>328B</span>","children":null,"spread":false},{"title":"newT3-1.sql <span style='color:#111;'>2.15KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"chapter1","children":[{"title":"上机部分","children":[{"title":"教学幻灯片","children":[{"title":"LG1V1.0.ppt <span style='color:#111;'>1.49MB</span>","children":null,"spread":false}],"spread":true},{"title":"源代码","children":[{"title":"LG1","children":[{"title":"网上书店(第一章上机).vsd <span style='color:#111;'>130.00KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"理论部分","children":[{"title":"教学幻灯片","children":[{"title":"TP1V1.0.ppt <span style='color:#111;'>2.35MB</span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"教学部分","children":[{"title":"补充案例","children":[{"title":"学校E-R图绘制.ppt <span style='color:#111;'>1.62MB</span>","children":null,"spread":false},{"title":"将现有的E-R图链接到数据库.doc <span style='color:#111;'>45.50KB</span>","children":null,"spread":false}],"spread":true},{"title":"附加题答案","children":[{"title":"附加题3.doc <span style='color:#111;'>110.50KB</span>","children":null,"spread":false},{"title":"附加题2.doc <span style='color:#111;'>46.50KB</span>","children":null,"spread":false},{"title":"网上书店E-R图.vsd <span style='color:#111;'>90.50KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]