网上订餐系统

一、实验目的 1）理解视图的概念。 2）掌握创建视图的方法。 3）掌握更改视图的方法。 4）掌握用视图管理数据的方法。 二、实验内容 3、用T-SQL语言创建、管理视图 （以下题目需提交） （1）创建视图 1）创建一个名为stuview2的水平视图，从数据库XSGL的student表中查询出性别为“男”的所有学生的资料。并在创建视图时使用with check option。（注：该子句用于强制视图上执行的所有修改语句必须符合由Select语句where中的条件。） T-SQL语句为： Create view stuview2 As Select * From student Where sex= 男 -1, experimental purposes 1) understand the concept of view. 2) to master the method to create the view. 3) control to change the view method. 4) The master with the view of management data. Second, the contents of three experiments, using T-SQL language to create, manage view (the following topics should be submitted) (1) create a view of a) Create a file called stuview2 level view of the student table from the database query XSGL the gender as " male " All the students information. Used in the creation of the view with check option. (Note: This clause is used to force all the modifications performed on the view must be consistent with statements

通过串口接收数据，并把接收到的数据保存到数据库中-recive data from serial prot and save the data to the database

SQL sever 2000中数据库查询的学习资料，需要的请下载-SQL sever 2000 database query in the learning materials need to download ...

BDA mysql component for accessing mysql databases

学生根据学号和密码进行登录，可以选择练习模式 登录后可以选择题型、难易程度进行自动组卷-Students according to learning and password to log in, you can choose to exercise the option after the model log questions, ease of Automatic Test Paper

SQL数据库语法教程，深入了解SQL，对于初学者很有帮助-Grammar SQL database, in-depth understanding of SQL, very helpful for beginners

MSSQL2000海量数据分页的存储过程代码-MSSQL2000 Massive Data Storage pagination process code

《SQL Server 2000课程设计案例精编》-李昆（案例四 企业员工资料管理系统）利用VB+SQL Server 2000进行课程设计，用一个通用的企业员工资料管理系统来介绍人事管理系统的实现过程。 案例四 企业员工资料管理系统 4.1 程序设计目的 4.2 程序功能介绍 4.3 程序设计 4.3.1 后台数据库设计 4.3.2 类模块设计 4.3.3 用户登录系统设计 4.3.4 系统主界面设计 4.3.5 员工信息管理系统设计 4.3.6 员工工资管理系统设计 4.3.7 员工部门/职务变动管理系统设计 4.3.8 用户管理系统设计 4.4 小结 4.5 课后作业 4.6 答案解析( SQL Server 2000 Short Course Design Case - Li Kun (case IV employees the information management system) using VB+ SQL Server 2000 for curriculum design, use of a common information management system for enterprise employees to introduce the personnel management system to achieve the process. Four cases of employee data management system designed to process 4.1 program features 4.2 Programming 4.3.1 Introduction 4.3 Background 4.3.2 database design class module design 4.3.3 users sign-on system design 4.3.4 System 4.3.5 main interface design information management staff System 4.3.6, wages and salaries of employees Management System 4.3.7 Department/job change management system design 4.3.8 User Management System 4.4 operating 4.6 Summary 4.5 after-school answer to resolve)

此源码关于如何在SQL SERVER 2005编程实现基础到高级管理的操作-This source code on how to program in SQL SERVER 2005-based operations to senior management

SQL200自定义函数MD5加密,测试-MD5