数据库笔记

暑假做的一个简单的fruit 网站 包含后台程序。 asp + SQLSERVER2005 -Summer to do a simple site contains fruit daemon. asp+ SQLSERVER2005

GMS 148 SHOP SQL 本源码为冒险岛国际服148版源码

合工大 数据库原理 上机实验 实验九 触发器的创建与使用 实验十 存储过程的创建与使用 实验十一 用户管理操作 (Co-workers on the experimental database principle experiment nine triggers the creation and use of stored procedures Experiment 10 Experiment 11 was created with the use of user management operations)

汽配管理系统源程序,可以了解组合框及表格打印等应用,适合初学者。-Auto Parts Management System source code to understand the combo boxes and forms printing applications, suitable for beginners.

图书管理系统，用于管理图书室里的图书的信息。-Library management system for managing library book information.

实用的毛织生产管理系统，MSSQL作后台，建立数据库手建立别名即可运行。-Knitwear practical production management system, MSSQL for the background, the establishment of a database can create an alias to run hands.

车站售票管理系统要求具有方便、快速的销售功能，包括车票的预订和退票的功能，能够支持团体的预订票和退票；能准确地了解售票情况，提供多种查询和统计功能，如车次的查询、时刻表的查询；能按情况所需实现对车次的更改、票价的变动及调度功能；有完善的报表系统；-Station ticket management system requires a convenient, fast sales functions, including ticket booking and refund the functions that can support group booking tickets and refund can accurately understand the ticketing situation, provides a wide range of query and statistical functions, such as trips of query, the query schedule can realize as the case may require changes to vehicle trips, the fare changes and scheduling functions statements have sound systems

1. 掌握SQL的数据定义、数据操纵功能 2. 利用SQL语句进行多表查询和嵌套查询 3. 掌握SQL数据定义中修改、删除表功能 4. 掌握SQL语句中数据更新相关操作 5. 掌握视图基本操作：定义、查询、更新视图。 (1. Grasp the SQL data definition, data manipulation functions 2. The use of SQL statements for multi-table query and nested query 3. Master modify SQL data definition, delete the table function 4. Grasp the SQL statement to update data related to operations 5. Master view basic steps: define, query, update the view.)

我编写的用ado访问sql server2000的小程序，希望对大家在编写访问数据库时能有所帮助！-I prepared with the sql SERVER2000 ado visit the small program, and I hope to visit you in the preparation of the database can be helped!

vb6环境下的学生管理系统，有sql脚本自动生成sql数据库。 系统完整，结构清晰，适合初学者调试理解！-VB6 environment student management system has automatically generated sql script sql database. System integrity, structural clarity, suitable for beginners to understand debugging!