使用T-SQL编写存储过程

此源码关于如何在SQL SERVER 2005编程实现基础到高级管理的操作-This source code on how to program in SQL SERVER 2005-based operations to senior management

SQL demistified:It is often said that mathematics is the language of science. In just the same way, SQL is the language of databases. My fi rst book, Databases Demystifi ed, introduces SQL, but focuses on database design. A number of readers asked for more detail about SQL because they found writing and running database queries to be so enjoyable. So, here is SQL Demystifi ed, devoted entirely to the SQL language.

VB6.0 SQL Server 2000下开发的。VB+SQL三层商品进销存管理系统。毕业设计做的，整理了一下。很好的系统。-VB6.0 SQL Server 2000 under the development. VB+ SQL three-tier commodity Invoicing management system. Graduation design done, finishing a bit. A very good system.

用VC和SQL Server开发的固定资产管理系统，包括系统信息管理，固定资产管理和统计查询管理三个大模块-VC and SQL Server development of the fixed asset management system, including system information management, fixed asset management and statistics for the three management module

考勤管理系统: 初始登录的用户和密码均为KQ-attendance management system : initial login and password of the users were Application of KQ

实用的毛织生产管理系统，MSSQL作后台，建立数据库手建立别名即可运行。-Knitwear practical production management system, MSSQL for the background, the establishment of a database can create an alias to run hands.

一个采用VS2008+Sql2000开发的任务管理系统，功能比较简单 有任务管理和角色管理等 DB_51aspx下为Sql数据库，附加即可 默认登录帐号/密码：51aspx/51aspx -Using VS2008+ Sql2000 a task management system development, functions are relatively simple task management and role management DB_51aspx for Sql database, additional to the default login name/password: 51aspx/51aspx

PFC是什么？ Powerbuilder Foundation Class PFC就是Sybase公司给我们做好的混凝土预制件（即扩展的对象），我们可以拿来用，这些对象具有新的功能，使我们在开发过程中事半功倍。  

在SQL Server2008下开发的图书销售管理系统，是一个典型的进、销、存数据库系统。功能类似一个书店，库存不足提醒进货，书籍分类、卖书、图书分类等(In SQL Server2008 developed under the book sales management system, is a typical, sales, keep the database system. Function similar to a bookstore, inadequate stock alert purchase, books classification, booksellers, book classification)

SQL常用函数总结.doc 包括了主流的各种数据库。是实际应用中的总结。(Summary of commonly used SQL functions. Doc, including the mainstream of the various databases. Is a summary of practical application.)