(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：NOT IN子查询.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":"NOT EXISTS查询.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":"创建和修改 PRIMARY KEY 约束.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":"使用 WITH RECOMPILE 选项.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}]