-
SQLPServerP2008Practice
SQL Server 2008实战pdf,基本的SQL语句,执行捕获跟踪数据修改、事务锁定阻塞死锁、触发器、CLR、以及安全等等,结合实战讲解。(SQL Server 2008 Practice pdf file,SQL Server 2008 actual pdf, the basic SQL statement, the implementation of capture tracking data modification, transaction locking block deadlock, trigger, CLR, and security, combined with actual combat explanation.)
- 2017-01-10 09:38:25下载
- 积分: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
-
一个公司的客户财产管理系统vb源码,5人团队共同开发完成
一个公司的客户财产管理系统vb源码,5人团队共同开发完成-a company"s customer property management system vb source, the five-man team completed joint development
- 2022-07-14 13:37:18下载
- 积分:1
-
在数据库中实现全文检索,实现按时间按分类进行索引,加快检索速度...
在数据库中实现全文检索,实现按时间按分类进行索引,加快检索速度-Index and Search for Ms Database , vc source.
- 2023-08-19 10:45:03下载
- 积分:1
-
sql
数据库从SQL Server 2008版本降低到2005(Reduced from SQL Server 2008 database to version 2005)
- 2013-12-21 09:55:53下载
- 积分: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
-
CreateWord
将SQL数据库的结构输出为一个word文档,包括字段的名称、类型、长度等信息(SQL database structure will be output as a word document, including the field name, type, length and other information)
- 2007-11-04 12:22:27下载
- 积分:1
-
连接数据库方法,能通用与各种数据库,只需要调用接口
连接数据库方法,能通用与各种数据库,只需要调用接口-connect to the database that should be universal with a variety of databases, need only call interface
- 2022-04-28 15:36:54下载
- 积分:1
-
against the source is the development of small and medium
本源码是针对中小型超市而开发的超市管理系统,使用方便-against the source is the development of small and medium-sized supermarkets and supermarket management system, easy to use
- 2022-02-01 03:49:33下载
- 积分:1
-
学生档案管理系统,是基于C++ Builder和SQL编程…
学生档案管理系统,是基于c++BuildER和SQL的编程的-Student file management system, is based on the c++ BuildER and SQL programming the
- 2022-05-12 14:07:12下载
- 积分:1