-
一、实验目的
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
-
own database operations, using them more convenient
自己封装的数据库操作类,使用起来比较方便-own database operations, using them more convenient
- 2023-03-16 05:35:03下载
- 积分:1
-
ssd7 exam2 questions and answers choice practice
ssd7 exam2 答案 仅供参考 选择题和练习题全都有
-ssd7 exam2 questions and answers choice practice
- 2022-01-26 16:50:58下载
- 积分:1
-
0072262249
SQL demistified:It is often said that mathematics is the language of science. In just the same way,
SQL is the language of databases. My fi rst book, Databases Demystifi ed, introduces
SQL, but focuses on database design. A number of readers asked for more detail
about SQL because they found writing and running database queries to be so
enjoyable. So, here is SQL Demystifi ed, devoted entirely to the SQL language.
- 2013-03-15 05:25:08下载
- 积分:1
-
RecieveMessage1
通过EXCEL VBA提取和插入SQL记录(through Excel VBA SQL insert and extract records)
- 2007-05-23 10:54:48下载
- 积分:1
-
blogsql
visual studio 2005
- 2008-09-11 12:54:49下载
- 积分:1
-
一段编程源码程序,一些PB窗口的定义并说明
一段编程源码程序,一些PB窗口的定义并说明-Some programming source code program, a number of PB and explain the definition of the window
- 2022-10-27 09:25:03下载
- 积分:1
-
The use of MFC and SQL resources management system, source code detailed descrip...
使用MFC和SQL实现资源管理系统,源代码中有详细的使用说明-The use of MFC and SQL resources management system, source code detailed description of the use of
- 2023-06-28 05:25:04下载
- 积分:1
-
本软件是一款由VS2005+SQL2005平台开发的学生成绩管理系统,如有问题请及时联系。...
本软件是一款由VS2005+SQL2005平台开发的学生成绩管理系统,如有问题请及时联系。-This software is a platform from VS2005+ SQL2005 student achievement management system, any questions please contact.
- 2023-04-18 14:25:04下载
- 积分:1
-
using连接数据库,执行SQL命令,使用适配器返回数据集。我们不需要去关心它的conn的资源是否关闭。当我们不用到它时。系统自动帮我们安全关闭...
using连接数据库,执行SQL命令,使用适配器返回数据集。我们不需要去关心它的conn的资源是否关闭。当我们不用到它时。系统自动帮我们安全关闭-using to connect the database, the implementation of SQL commands, use the adapter to return data sets. We do not need to care about it whether the resources conn closed. When we do not have to it. Automatic safety system shut down to help us
- 2023-07-16 05:05:03下载
- 积分:1