SQL-Function

汽车4s店库存管理系统，有入库，出库，分类汇总等功能-4s shop car inventory management systems, has put in storage, a library, such as classification of aggregate functions

应用Visual c++.net连接数据库事例(ODBC)-Visual c. Net to connect to the database instances (ODBC)

VB+sql图书管理系统　　学习用　带源代码-VB+ Sql learning library management system used with the source code

SqlServer2005数据库恢复，附加模式或文件模式-SqlServer2005 database recovery, the additional model or document mode

数据库从SQL Server 2008版本降低到2005(Reduced from SQL Server 2008 database to version 2005)

VC上用ADO接口方式访问SQL Server 2005 测试程序(VC on the interface with ADO access to SQL Server 2005 test program)

VC++语言实现与数据库的连接，效果不错的-VC++ Language with database connectivity, the effect of good

一个科研管理系统，用于管理项目，是基于SQL和VC的一个系统-A research management system for managing projects, is based on SQL and VC of a system

开源的cms非常棒 开源的cms非常棒-Open source cms open source cms great great

一、实验目的 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