本篇文章介绍了安装SQL Server 2000企业版的软硬件配置要求，安装过程的详细步骤,以及初步使用SQL Server 2000....

在SQL中删除重复记录 学习sql有一段时间了，发现在我建了一个用来测试的表（没有建索引）中出现了许多的重复记录。后来总结了一些删除重复记录的方法，在Oracle中，可以通过唯一rowid实现删除重复记录；还可以建临时表来实现...这个只提到其中的几种简单实用的方法，希望可以和大家分享（以表employee为例）。-SQL delete duplicate records sql learning for a long time, I found in a building used for the test (not built Index) There"s a lot of duplication of records. Later up in the deletion of duplicate records, Oracle, can only achieve rowid delete duplicate records; Also temporary tables can be built to achieve ... the only mention of several simple, practical methods, and we hope to share (table employee example).

在VC中用DB-Library快速访问SQL Server数据库技术-in VC DB-Library quick access to SQL Server database technology

vb6环境下的学生管理系统，有sql脚本自动生成sql数据库。 系统完整，结构清晰，适合初学者调试理解！-VB6 environment student management system has automatically generated sql script sql database. System integrity, structural clarity, suitable for beginners to understand debugging!

系统应具有售票、查询、管理和维护等功能，系统管理员可以进行对车次的更改、票价的变动及调度功能，车次调度可通过对发车时刻表的修改来进行，维护功能即可对表进行修改。-System should have the ticket, query, management and maintenance functions, the system administrator can change on the trips, the fare changes and scheduling functions, scheduling trips to the departure schedule could be adopted to carry out modifications, maintenance functions can be on the table be modified.

一 开发环境 OS: Windows 2000 Server + SP2 IDE: Visual Studio 6.0 + SP5 DataBase: SQL 2000 Server + SP2 二 运行 1：创建数据库 将TRADE.sql中的SQL语句考入SQL Server的查询分析器中，全部运行； 2：建立ODBC数据源 数据原名称为Trade_MIS-a development environment OS : Windows 2000 Server SP2 IDE : Visual Studio 6.0 SP5 DataBase : SQL Server 2000 running a two SP2 : TRADE.sql database will be created in the SQL Server SQL admitted to the inquiry Analyzer all operations; 2 : build ODBC data source data formerly known as Trade_MIS

基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI），很难得的例子，现在国内资料特别少。-based sqlserver2k, reporting service expansion (auth, render, and deliver ==) Application (mssql, RS, AS, BI), a rare example, the domestic information is particularly scarce.

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

一个高校学籍管理系统 源代码完成了以下功能： 1)能够从屏幕上读取一个学生的信息并将信息存入到数据文件中。 2)能够将指定的信息从文件中删除。 3)能够按编号、姓名对学生的信息进行检索并将检索结果显示在屏幕上。 4)可以统计全部学生的总成绩，及其在班上的排名。 5)能够统计各科的平均成绩及及格率。 6)要求有错误提示功能，例如性别只能输入男女，输入错误提示重新输入。 7)如果检索不到相应的信息应提示用户。-a source code management system to complete the following functions : 1) to read from the screen of a student information and information into the data file. 2) can be designated information deleted from the document. 3) to by number, name of student information retrieval and search results displayed on the screen. 4) Statistical all students can be a total score, and the class rankings. 5) Statistics Branch to the average scores and passing rates. 6) require a functional errors, such as sex between men and women can only import, import errors to re-enter. 7) If less than the corresponding retrieval of information should prompt the user.

使用 php 和 mysql 的工资系统。嗨，这个项目基本上是以帮助您工资单系统联机。它 conatins javascript 和 php 和 mysql 的职能。要当心，这会对基本上是任何人都有用。有乐趣和享受 ！欢呼。......

说明：  sql2000工程实践一书第8张源代码，可以直接调试 (SQL2000 engineering practice of a book section 8 Zhang code, debugging can be directly)