常用SQL语句开发实例!

使用Java开发的数据仓库OLAP程序，后台是Oracle 10Ｇ　１０．０．０．３　前台使用Ｊｄｅｖｅｌｏｐｅｒ开发。-use Java development OLAP data warehouse procedures, background Oracle 10G 10.0.0.3 use JDeveloper development prospects.

ISBN：7502607862 作者：林理忠 出版社：北京 : 中国计量出版社 年份：1996 页数和开本：328页 19cm -ISBN: 7502607862 Author: Lin Zhong Publisher: Beijing: China Metrology Publishing House Year: 1996 Length and format: 328 19cm

读出XML文件并且用树形目录形式显示在对话框CTreeCtrl控件中.源代码来自他人,我把它转换到了VC6.0环境下,并且删除了一个提示消息,希望可以提供更多的便利.谢谢原作者-Read XML files and directories with the tree displayed in the dialog box CTreeCtrl control. The source code from the others, I see it converted to the VC6.0 environment, and removed a prompt message, hoping to provide more convenience. Thank you, the original author

ADO编程技术,数据库开发，非常不错的书。 比较全面，是VB的例子-ADO programming techniques, database development, a very good book. More comprehensive, are examples of VB

使用DAO的交互式输入执行SQL语句，并显示结果的程序-The example of excuting SQL alternatively by DAO and displaying the result

本程序是设计一个通讯录，使其具有简单的数据库功能，如插入，删除，修改等实际应用功能。VC++和ODBC是用于创建数据库程序很好的工具，就快速开发和使用简便而言，这两个工具是最好的选择。所以我选用ODBC来进行数据库程序的开发。-this program is to design a directory, it will have a simple database functions, such as the insertion, deletion, modification and other practical applications. VC and ODBC database is used to create procedures good tools, rapid development and easy to use, the two tools is the best option. I chose to ODBC database development.

微软的SQL SERVER数据库的Image、text等字段都属于二进制的大对象。这些对象的存取和其他轻型对象略有不同。 　　微软.NET Framework的System.IO命名空间下给我们提供了一个FileStream文件流类。我们可以使用这个文件流对二进制大对象轻松进行读写。 　　我实现了一个简单的WinForm程序，这个程序通过点击“Open”按钮选择一个bmp或者jpg文件，并显示在图形控件PictureBox中。通过“Save”按钮存入数据库。点击“View”CheckBox可以切换到浏览状态，观看存入数据库的图片。 　　由于对二进制大对象使用的流操作，所以对于任何文件都具有通用性。读写文本文件也可以这么做。 -Microsoft s field and so on SQL SERVER database Image, text all belongs to binary the big object. These objects deposits and withdrawals and other light objects have the difference slightly. MicrosoftNET Framework System.Under the IO naming space provided a FileStream document to us to flow the kind. We may use this document to flow to the binary big object with ease carry on read-write. I have realized a simple WinForm procedure, this procedure through clicks on "Open" the button to choose bmp or the jpg document, and the demonstration controls in PictureBox in the graph. The button stores the database through "Save". Clicks on "View" CheckBox to b

上面代码的一个补充-An update for above code

主要是用ODBC实现对MDB数据格式文件的数据库的访问-ODBC is mainly used to achieve data format MDB database file access

这是一个精美的进出贷单的协助软件,要运行程序必须将数据库文件bills.mdb与可执行文件放在一起， 如果在vc开发环境中运行，则需要将该数据库文件放在工程目录下-This a beautiful single out loans with the assistance of software to run programs must be bills.mdb database files and executable files are placed together, if vc Development Environment operation, the need to be placed on engineering database files directory