用于指导初学者，掌握SQL的基本命令和操作

ASP[1].NET在线SQL数据库企业管理器v0.13(C#源码提供),希望对大家有用-ASP [1].NET online database SQL Enterprise Manager v0.13 (C# source code provided) , a member of the useful

c#数据库编程经典实例,非常不错，采用SQL 2005，里面的数据库连接之类的类可以拿来用-c# Database Programming classic example of very good, using SQL 2005, which like the database connection class can be used with

通过本实验加深对SQL Server 2000环境下数据定义语言的理解，能够熟练地建立数据库，并通过SQL语句来建立一个新的SQL Server设备管理数据库，使用SQL的数据定义功能建立数据库中的各个基本表（共3个），并按要求对有关表进行修改。 每次操作后通过企业管理器查看有关对象的变化。创建和修改基本表、创建和取消索引。-Through better understanding of this experiment under SQL Server 2000 data definition language understanding, able to skillfully build up a database, and through the SQL statements to create a new SQL Server Device Manager database, use SQL data definition, function to establish a database of all the basic table (a total of three), as required on the table to edit. After each operation through the Enterprise Manager view information about the object changes. Create and modify the basic form, the creation and abolition of the index.

可实现仓库管理，vc开发，SQL SERVER为后台数据库，界面良好-achieve warehouse management, vc development, SQL Server database for the background, a good interface

数据库方面的知识 最基本的建表，还有表之间的连接 请大家批评指正 -err

B/S版ERP安装方法 1、安装IIS5.0、Microsoft .NET Framework 1.1及SQL Server2000 2、将目录Copy_of_ERP和webctrl_client复制到C:/Inetpub/wwwroot下，并将Copy_of_ERP目录设置成IIS虚拟目录 3、在SQL Server2000中新建一个Storage用户和LXTXERP数据库，然后将Data目录中的LXTXERP.BAK数据库备份文件还原 4、修改Copy_of_ERP目录下的Web.config文件的连接属性sa用户的密码： 5、在Windows管理工具中打开Internet 服务管理器，运行Copy_of_ERP中的Login.aspx打开ERP登录页面，默认用户：admin 密码：123 6、OK-B/S version of ERP installation method 1, the installation IIS5.0, Microsoft. NET Framework 1.1 and SQL Server20002, will webctrl_client directory Copy_of_ERP and copied to C:/Inetpub/wwwroot under Copy_of_ERP directory and IIS virtual directory set to 3, in SQL Server2000 in Storage to create a new user and LXTXERP database, and then Data directory LXTXERP.BAK database backup file to restore the 4, to amend Copy_of_ERP directory Web.config file Connection Prop

一个简单的学分管理数据库系统 供老师管理学生学分  如添加，修改学生各科成绩，方便管理学分 而不必一一去修改每课成绩信息

在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).

售票系统四川拓展软件开发研究所是一家民营高科技企业，专门从事计算机应用软件的研究开发。我所以现代股权制度为纽带，凝聚了一批技术水准高，充满活力，勤奋敬业的软件研发人才，主要致力于公路运输企业和医院管理软件的研发。-ticketing system to expand Sichuan Institute of Software Development is a private high-tech enterprises, specializing in computer application software research and development. I have a modern system of ownership as a link, the combination of a number of high technical standards, vibrant, hardworking software research and development personnel, committed to the main road transport enterprises and hospital management software research and development.

sql Server数据更新部分习题代码(Problem Code section sql Server data updates)