-
SQL_notes
More SQL notes from College.
- 2013-03-19 17:45:37下载
- 积分：1
-
SQL Server 2000 backup, using Delphi7 achieved, you are welcome to download!
SQLSERVER2000备份,用delphi7实现的,欢迎您下载使用!-SQL Server 2000 backup, using Delphi7 achieved, you are welcome to download!
- 2022-01-26 03:03:50下载
- 积分：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
-
2005sql.rar很好
2005SQL.rar
相当不错,美观大方-2005SQL.rar pretty good
- 2022-05-29 17:28:02下载
- 积分：1
-
几个老外写的源代码大家块块下载
几个老外写的源代码大家块块下载-Several foreigners to write the source code for everyone to download块块
- 2023-02-07 17:25:04下载
- 积分：1
-
wage management system management system for wage wage wage management system ma...
工资管理系统工资管理系统工资管理系统工资管理系统
- 2022-01-25 20:40:55下载
- 积分：1
-
SQL server common statement is the classic collection does not see you suffer
SQL server 中常用的语句，是收藏的经典，不看你吃亏-SQL server common statement is the classic collection does not see you suffer
- 2023-05-29 03:25:03下载
- 积分：1
-
一个c++编写的人事管理系统，包含了数据库配置文档、系统描述文档。...
一个c++编写的人事管理系统，包含了数据库配置文档、系统描述文档。-A c++ written in the personnel management system, contains a database configuration documentation, the system described in the document.
- 2022-06-01 17:43:57下载
- 积分：1
-
based sqlserver2k, reporting service expansion (auth, render, and deliver ==) Ap...
基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI），很难得的例子，现在国内资料特别少。-based sqlserver2k, reporting service expansion (auth, render, and deliver ==) Application (mssql, RS, AS, BI), a rare example, the domestic information is particularly scarce.
- 2022-07-03 13:14:00下载
- 积分：1
-
display of the code DB_LIB the use of SQL Server connectivity and various operat...
本代码展示了使用DB_LIB库对SQL SERVER的连接和各种操作的实例。-display of the code DB_LIB the use of SQL Server connectivity and various operational examples.
- 2022-07-17 03:08:13下载
- 积分：1
