Teach Yourself SQL in 21 Days Second Edition

用C编写的短小精悍的数据库，既有运行码，又有源代码，支持APPEND,DELETE,SAVE,LOAD,INSERT,SHOW,FIND,SORT,CLOSE,MODIFY,QUIT,HELP等命令，对于想学习如何用C实现数据库sql语句编程的同仁很有帮助。-Prepared by C dapper database, both running code, and source code, support for APPEND, DELETE, SAVE, LOAD, INSERT, SHOW, FIND, SORT, CLOSE, MODIFY, QUIT, HELP, such as orders, who want to learn how to C database programming sql statement Tongren helpful.

在SQLSERVER数据库查找任一表中的任意数据-SQLSERVER database in the search for a form of arbitrary data

一个功能简单的图书馆管理系统，但是基本功能都已经实现，界面简洁漂亮．-a simple function of the library management system, but the basic functions have now been achieved, pretty simple interface.

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

java中sql server的连接的两种方法，值得参考 -java in the sql server connection two methods, it is also useful

一个图书管理系统，vc环境开发，里面有详细的源代码-A library management system, vc environmental development, there are details of the source code

利用VB把图片插入SQLServer数据库,并将数据库中的数据和图片导出到Word中(word中使用宏录制)-VB Pictures inserted SQLServer database and the data in the database is derived and pictures to Word (word-use recording)

包含了浪潮的采购数据结构、库存管理数据结构、销售数据结构、浪潮财务数据结构等-contain a wave of procurement data structure, data structure inventory management, sales data structure, wave of financial data structures, etc.

sql中检索行列转换,将多行的数据转成一行,然后增加列数-The ranks of the conversion

说明：  SQL2005通过存储过程实现金额转账功能(SQL2005 stored procedure through the realization of the amount of the transfer function)