-
viaual c+++ sqlsever database application system development and code examples i...
viaual c++ + sqlsever 数据库应用系统开发与实例 第三章代码-viaual c+++ sqlsever database application system development and code examples in Chapter III
- 2022-07-13 12:52:08下载
- 积分:1
-
插入文本文件到数据库中
插入文本文件到数据库中-insert text documents to the database
- 2022-02-01 18:26:29下载
- 积分:1
-
SQL2005transfer
说明: SQL2005通过存储过程实现金额转账功能(SQL2005 stored procedure through the realization of the amount of the transfer function)
- 2008-11-20 12:59:52下载
- 积分: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
-
MyApp3
SQL sever 的学生选课系统作业。方便新手作为参考。(SQL sever student elective system operations. Facilitate the novice as a reference.)
- 2013-06-05 16:35:21下载
- 积分:1
-
关于sql函数的一些个人总结,部分资源是在网上查到的,还有待完善,可以的话,朋友们可以帮忙补全...
关于sql函数的一些个人总结,部分资源是在网上查到的,还有待完善,可以的话,朋友们可以帮忙补全-Sql function on some of my personal summary of some of the resources is available online, and have yet to be perfect, if you can, friends who can help fill the whole
- 2022-04-26 10:13:40下载
- 积分:1
-
用ADO+CListCtrl操作SQL的示例程序,可方便地进行删除,更新,添加数据到SQL服务器。(网上非常少)。其中在ADOConn类中的Server和Dat...
用ADO+CListCtrl操作SQL的示例程序,可方便地进行删除,更新,添加数据到SQL服务器。(网上非常少)。其中在ADOConn类中的Server和Database 应根据所在的具体环境进行修改,
希望对广大VC++爱好者有所帮助。-With ADO+ CListCtrl operation examples of SQL procedure can be easily delete, update, add the data to SQL server. (Online is very little). In category adoconn Server and Database should be based on the specific environment where amended in the hope that the general VC++ Lovers help.
- 2022-01-20 23:46:19下载
- 积分:1
-
这是自己曾经参与开发的轻纺管理系统B/S版,有一定的研究价值!...
这是自己曾经参与开发的轻纺管理系统B/S版,有一定的研究价值!-This is what they have to participate in the development of light and textile industry management system B/S version, which is the research value.
- 2022-01-28 14:52:34下载
- 积分:1
-
对SQL数据库项目的脚本。
script of the sql data base of the project that.
- 2022-02-05 21:53:18下载
- 积分:1
-
SQLserver2003的java数据库驱动内含三个(msbase.jar mssqlserver.jar msutil.jar)
希望对大家有所作用...
SQLserver2003的java数据库驱动内含三个(msbase.jar mssqlserver.jar msutil.jar)
希望对大家有所作用-The java database-driven SQLserver2003 containing three (msbase.jar mssqlserver.jar msutil.jar) the role of hope all of you
- 2022-03-07 15:17:50下载
- 积分:1