display of the code DB_LIB the use of SQL Server connectivity and various operat...

一 开发环境 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

说明：  sp executesql动态SQL变量传递(sp executesqlsp executesql)

Notes on Dynamic SQL

网上选课，可进行选课，注销，更改基本信息功能-online classes, classes can be conducted, cancellations, changes in the basic functions of information

酒店客房管理系统，很详细的资料和介绍，还有数据库文件-Hotel rooms management system, a very detailed information and presentation, as well as database files

材料库管理软件,很好啊 材料库管理软件,很好啊-Materials library management software, ah good material base management software, good ah

用于指导初学者，掌握SQL的基本命令和操作-Used to guide the beginners to master the basic SQL commands and operations

不使用任何组件，可以侦测局域网内的主机是否安装sql server，和sql server的名称等信息。使用方法：detectSQL 192.168.21.231-not use any components, can detect LAN mainframe installed sql server and sql server"s name and other information. Use : detectSQL 192.168.21.231

我使用的平台的是VS2010和SQL server 2008,通过ODBC连接数据库(C++ connect to the database There are many ways, and SQL server in Visual C++ the actual development, in general, to use ODBC or ADO technology for development, related technologies and products are also the most mature. Here we need to use ODBC based curriculum approach.)

OraclePLSQL很好的一本教程 可以打印 内容很详细-OraclePLSQL a very good tutorial can print the contents of a very detailed