-
一、实验目的
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
-
详细收集整理各种SQL的操作语句
是从零基础到精通的必胜法宝...
详细收集整理各种SQL的操作语句
是从零基础到精通的必胜法宝
-Collected in detail the operation of a variety of SQL statements is the basis from zero to the master of the magic weapon to win
- 2022-11-27 23:30:03下载
- 积分:1
-
SQL
有关已知数据库Student,course,SC,的20条SQL语言极其表示的意义(Information on known database Student, course, SC, the 20 represents the significance of the SQL language is extremely)
- 2013-07-06 15:17:59下载
- 积分:1
-
比较可以的源码,关于dbhelper的 非常号,非常实用
比较可以的源码,关于dbhelper的 非常号,非常实用-It s about dbhelper,itis convenient
for your softw development
- 2022-07-22 01:11:04下载
- 积分:1
-
sql anywhere studio 9 developers guide
sql anywhere studio 9 developers guide
- 2022-05-30 19:39:26下载
- 积分:1
-
一个功能完善的论坛系统,有数据库备分,希望对你有所帮助
一个功能完善的论坛系统,有数据库备分,希望对你有所帮助-Perfect forum for a functional system that has the database backup, and they hope to help you
- 2022-01-26 06:54:20下载
- 积分:1
-
A small hotel management system, is learning the meaning of. Simple and practica...
一个小型的酒店管理系统,很有学习意义.简单实用.-A small hotel management system, is learning the meaning of. Simple and practical.
- 2022-04-07 19:05:42下载
- 积分:1
-
Rummery
说明: 酒店管理系统后台数据库存储过程,实现添加房间,修改房间信息和管理人员的信息。(Hotel management system back-end database stored procedure, the realization of room to add, modify room information and management information.)
- 2008-11-12 15:54:01下载
- 积分:1
-
天通sql21自!PDF文件打包下载!SQL入门很好的SE…
SQL21日自学通!PDF文件打包下载!
SQL入门非常好的自学教材-Day pass SQL21 self! PDF file download package! SQL Introduction to very good self-study materials
- 2023-03-10 15:50:04下载
- 积分:1
-
MySQL的最详细帮助文件
MySQL的最详细帮助文件,对初学mysql的朋友具有一定的帮助
- 2022-05-30 10:51:33下载
- 积分:1