-
系统应具有售票、查询、管理和维护等功能,系统管理员可以进行对车次的更改、票价的变动及调度功能,车次调度可通过对发车时刻表的修改来进行,维护功能即可对表进行修改。...
系统应具有售票、查询、管理和维护等功能,系统管理员可以进行对车次的更改、票价的变动及调度功能,车次调度可通过对发车时刻表的修改来进行,维护功能即可对表进行修改。-System should have the ticket, query, management and maintenance functions, the system administrator can change on the trips, the fare changes and scheduling functions, scheduling trips to the departure schedule could be adopted to carry out modifications, maintenance functions can be on the table be modified.
- 2022-04-26 21:39:54下载
- 积分:1
-
一个很有意思的点菜系统前后台连接齐全~做课程设计的同学可以参考...
一个很有意思的点菜系统前后台连接齐全~做课程设计的同学可以参考-a very interesting system after Taiwan ordered link to complete the design courses so students can refer to
- 2023-07-10 03:40:03下载
- 积分:1
-
可以将局域网内的其它SQL Server2000数据库显示到列表框供用户灵活选择数据库...
可以将局域网内的其它SQL Server2000数据库显示到列表框供用户灵活选择数据库-LAN can be the other SQL Server 2000 database shows to the list box for users flexibility in choosing the database
- 2022-01-22 02:01:05下载
- 积分:1
-
DB_LIB use of the code to the SQL Server2000 and linking various operations, pro...
本代码使用DB_LIB库对SQL SERVER2000进行连接和各种操作,提供了一个实例。-DB_LIB use of the code to the SQL Server2000 and linking various operations, provide an example.
- 2022-09-27 02:00:02下载
- 积分:1
-
一个自制的药房销售管理系统,能录入,添加,删除和报告过期药品...
一个自制的药房销售管理系统,能录入,添加,删除和报告过期药品-a privately pharmacy sales management, logging, add, delete and report expired drugs
- 2022-05-26 08:14:33下载
- 积分:1
-
This is the SQL database as the Student Management System. A simple, but the bas...
这是用SQL数据库做的学生学籍管理系统。简明,但基本功能都能实现。以报告形式出现。有代码-This is the SQL database as the Student Management System. A simple, but the basic function can be materialized. A report form. Code
- 2023-07-28 19:45:03下载
- 积分:1
-
- 2022-06-11 12:43:57下载
- 积分:1
-
考勤管理系统:
初始登录的用户和密码均为KQ
考勤管理系统:
初始登录的用户和密码均为KQ-attendance management system : initial login and password of the users were Application of KQ
- 2023-09-03 16:10:03下载
- 积分:1
-
一、实验目的
1)理解视图的概念。
2)掌握创建视图的方法。
3)掌握更改视图的方法。
4)掌握用视图管理数据的方法。
二、实验内容
3...
一、实验目的
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
- 2023-09-08 05:20:03下载
- 积分:1
-
dreamwaver+asp用于SQLSERVER用户注册登陆和修改密码的动态网页源码...
dreamwaver+asp用于SQLSERVER用户注册登陆和修改密码的动态网页源码-dreamwaver asp for registered users SQLSERVER landing and modify passwords Dynamic Web Source
- 2022-01-24 09:47:32下载
- 积分:1