mcdba考试资料（70229） SQL Server 2000数据库程序设计模拟题

使用sql编写的小型商场数据库： （1）能记录每一笔进货，查询商品的进货记录，并能按月进行统计。 （2）能记录每一笔售货，查询商品的销售情况，并能进行日盘存、月盘存。 （3）能按月统计某个员工的销售业绩。 （4）在记录进货及售货的同时，必须动态刷新库存。 （5）能打印库存清单，查询某种商品的库存情况。

商业网站,具体的功能大家可以自己去看看,这些东西也只是为了我在网上下载东西才传上去的-Commercial websites, the specific features everyone can go and see, these things are only for things I downloaded before Chuan-up of

用SQL Server+jsp实现的电话黄页查询系统。 运行的时候，需要把database目录下的YellowPages_MSAccess.mdb文件拷贝到D盘根目录，因为在common.jsp中设置的数据库路径为根目录，读者也可以设置程其他路径。 将该目录拷贝到Tomcat的ROOT目录下，首页链接URL为http://localhost:8080/appendix2/Default.jsp。 注意：文件名是区分大小写的。-with SQL Server jsp achieve the Yellow Pages telephone inquiry system. Running time need directory database of the text YellowPages_MSAccess.mdb pieces copy to the D occurs, because the common.jsp set the path for the database root directory, readers can also set up other way path. This directory is copied to Tomcat ROOT directory and URL Links Page at http :// localhost : 8080/appendix2/Default.jsp. Note : The documents are case-insensitive.

基础SQL数据库知识小解，适合新手入门，知识全，内容广。(Basic knowledge of SQL database, suitable for novice entry, full knowledge, wide content.)

对于sql server2005数据库中，指定时间和频率，创建数据库作业，自动备份数据库。-About sql server2005 database, specify the time and frequency of homework to create the database, automatic backup of the database.

C/S模块，VB作为开发工具，后台数据库使用SQL Server2000,使用ADO方式连接数据库，实现开户、销户、存款、取款、修改密码、转账、挂失解挂等功能-C/S module, VB as the development tools, back-end database using SQL Server2000, connect the database using ADO, the realization of accounts, sales households, deposits, withdrawals, modify passwords, transfer, report the loss linked to the functions of solution

数据库连接，读，写，修改，储存，等等的函数！可以镶入任何的程序，这样编写数据库就节省了很多时间了！-Database connection, read, write, modify, store, and so the function! Can insert into any of the procedures, so that the preparation of database on save a lot of time!

一段编程源码程序，一些ＰＢ窗口的定义并说明-Some programming source code program, a number of PB and explain the definition of the window

LabVIEW调用动态链接库之参数问题！实现LAB与其他语言的连接-LabVIEW called dynamic link library, Parametric problem! LAB realization, and other languages link! !

简单操作Sqlite3的API封装，能够在空表的时候取得表的结果-Sqlite3 the API simple package that can form in the air when the results obtained in table