-
学生根据学号和密码进行登录,可以选择练习模式
登录后可以选择题型、难易程度进行自动组卷...
学生根据学号和密码进行登录,可以选择练习模式
登录后可以选择题型、难易程度进行自动组卷-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
- 2022-07-12 22:12:45下载
- 积分: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
-
management functions applicable to the PB to bring their own databases, through...
实现图书借阅管理功能,适用于PB自带数据库,通过PB实现界面的编辑-management functions applicable to the PB to bring their own databases, through PB interface editor
- 2022-07-20 00:28:20下载
- 积分:1
-
给SQL初学者的书,这本书讲得还挺详细的,向大家推荐
给SQL初学者的书,这本书讲得还挺详细的,向大家推荐-SQL beginners to the book, this book speak positively detailed, we recommend to you
- 2022-10-23 18:25:03下载
- 积分:1
-
SQL
在ClsDBContrl.cs类中完成修改数据库中数据的方法AmendDB.(Completed in ClsDBContrl.cs class method to modify the data in the database AmendDB)
- 2012-01-09 23:11:50下载
- 积分:1
-
script
sql about erm sql about erm(sql about ermsql about ermsql about erm)
- 2013-08-14 12:52:37下载
- 积分:1
-
SQLServer2005
SQLSERVER2005数据库是非常重要的,具备了以前版本的内容。(SQLSERVER2005 database is very important to have a previous version of the content.)
- 2011-06-25 10:20:25下载
- 积分:1
-
java for sqlserver 的驱动,是厂商提供的在做纯驱动时需要它
java for sqlserver 的驱动,是厂商提供的在做纯驱动时需要它-SQLServer for the driver is provided by the manufacturers to purely driven need it
- 2023-06-03 22:25:03下载
- 积分:1
-
本书学习SQL 2使用:1。在Win95。在Win98安装PWS(Win98中…
SQL学习宝典2.0的使用说明:
1.在win95,win98下要安装PWS(win98安装盘里有).
2.把sql2目录设为虚拟目录。
2.在浏览器中运行http://localhost/sql2/index.asp.
SQL学习宝典2.0的功能说明:
1.学习和检验SQL语句,输入SQL语句即可执行,及时显示结果。
2.assess数据库显示,显示数据库中的所有表名和所有表的记录,
包括字段类型。可以在conn.inc文件中把xx.mdb换成你自己的数据库名,
其他程序不用修改即可使用。
3.收藏大量经典SQL语句,用户可以添加收藏。
4.所有程序均有详细说明。是ASP+ACCESS的最好实例。是ASP程序员的好帮手。
使用对象:ASP编程人员,学习和使用SQL语句的人
-book learning SQL 2.0 for use : 1. In win95. win98 installed under PWS (win98 installation of a tray). 2. put sql2 Set Virtual Directory Contents . 2. The browser running http :// localhost/sql2/index.asp. learning SQL 2.0 treasury functions Note : 1. learning and testing the SQL statements in SQL input can be executed, timely result will be displayed. 2.assess database, the database shows all the tables in the name of the table and all records, including field type. The documents include the conn.inc xx.mdb replaced by your own database name. other procedures need not be amended in order to use. 3. A collection of cl
- 2022-08-16 19:05:26下载
- 积分:1
-
仓库管理系统,包含了一些基本的功能,界面也非常好
仓库管理系统,包含了一些基本的功能,界面也非常好-Warehouse management system, contains some basic functionality, the interface is also very good
- 2022-06-26 00:46:15下载
- 积分:1