『壹』 如何成為一個程序員
一個程序員應該具備的基礎知識和概念：
1、計算機是有什麼組成的，CPU是什麼東西，其工作原理是什麼。
2、機器語言和微指令集的概念。
3、程序的概念。
4、匯編語言是低級語言但不是機器語言。
5、高級語言主要有那些？（C，C＋＋，Basic，Pascal，Fortran，C#，Java等等；如果你是中國軟體業的英雄，你也寫一門語言，最好不用英語） 6、編譯程序和解釋程序的概念和其原理。（編譯器是高手和專家編寫的）
7、HTML、XML等是標識性語言。
8、Prolog是人工智慧語言。
9、操作系統OS的概念和原理。（Windows98，Windows2000，Windows NT，UNIX，Linux，等等都是OS，還有一些實時OS，嵌入OS，編這些的絕對是高手）
10、Windows編程說白了就是Windows API的調用。（中國的程序員很多隻是會編windows程序，用的是VB，我的建議是這些程序員頂多隻是低級編碼員，我稱其是coder）
11、VC＋＋、VB、BC、BCB、Delphi、VF等都只是編程的工具和環境，不是編程語言。
12、面向結構的設計概念。
13、面向對象的概念。（好好理解，兄弟，這個東西還是很重要的）
14、軟體工程的概念和原理。（如果你想當老總就需要好好研究了，系統分析員比編碼員要高一個等級，薪水也高喲）
15、資料庫的概念。（要熟悉一些著名的資料庫系統和語言的名字，如Orcle，sql，DB2，DyBase等）
16、了解網路概念。
17、了解多媒體概念。
18、熟悉和掌握數據結構和基本演算法。
『貳』 英文求職信
【必備】英文求職信範文集錦七篇
日子如同白駒過隙，不經意間，前方等待著我們的將是新的工作機會和挑戰，這時是不是該好好寫一封求職信了呢？那麼優秀的求職信都是怎麼寫的呢？下面是我為大家收集的英文求職信7篇，僅供參考，歡迎大家閱讀。
Again, thank you for reading my cover letter, no matter the outcome, please accept my heartfelt good wishes! I wish you successful work!
Sincerely
Salute!
Zhang xiaoming
Department of thermal engineering
Tsinghua university
BEijing of China 100084
英文求職信 篇7
Dear sir／madame,
Your advertisement for a network maintenance engineer in the april 10student daily interested me because the position that you de- scribed sounds exactly like the kind of job i am seeking.
According to the advertisement,your position requires a good university degree,bachelor or above in computer science or equivalent field and proficient in windows nt 4.0and linux system.i feel that i am competent to meet the requirements.i will be graating from xx university this year with a msc.my studies have included courses in computer control and management and i designed a control simulation system developed with microsoft visual and sql server.
During my ecation,i have grasped the principles of my major subject area and gained practical skills.not only have i passed cet - 6,but more importantly i can communicate fluently in english.my ability to write and speak english is a good standard.
I would welcome an opportunity to attend you for an interview.
Enclosed is my resume and if there is any additional information you require,please contact me.
Sincerely yours,
XXX
;『叄』 如何在web中使用activiti和sql server
一、按照如下方式新建一個web工程
之所以要用maven，主要是為了解決各種依賴項的問題，用maven來管理依賴項還是很方便的。
用Eclipse創建Maven結構的web項目的時候選擇了Artifact
Id為maven-artchetype-webapp，由於這個catalog比較老，用的servlet還是2.3的，而一般現在都是用3.0，在
Project Facets裡面修改Dynamic web mole為3.0的時候就會出現Cannot change version of
project facet Dynamic web mole to 3.0，如圖：
解決這個問題的步驟如下：
1. 把Servlet改成3.0，打開項目的web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
id="schele-console" version="3.0">
2. 修改項目的設置，在Navigator下打開項目.settings目錄下的org.eclipse.jdt.core.prefs
把1.5改成1.8
eclipse.preferences.version=1
org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.8
org.eclipse.jdt.core.compiler.compliance=1.8
org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
org.eclipse.jdt.core.compiler.problem.forbiddenReference=warning
org.eclipse.jdt.core.compiler.source=1.8
3. 打開org.eclipse.wst.common.project.facet.core.xml
把java改為1.8， 把jst.web改為3.0；
<?xml version="1.0" encoding="UTF-8"?>
<faceted-project>
<fixed facet="wst.jsdt.web"/>
<installed facet="jst.web" version="3.0"/>
<installed facet="wst.jsdt.web" version="1.0"/>
<installed facet="java" version="1.8"/>
</faceted-project>
二、解決報錯The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path
可以使用如下步驟來解決。
1、右擊web工程-》屬性或Build Path-》Java Build Path->Libraries-> Add Libray...->Server Runtime -》Tomcat Server
2、切換到Java Build Path界面中的Orader and Export，選擇Tomcat。
三、修改項目的pom.xml文件，添加activiti相關依賴項
相關依賴項如下：
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-engine</artifactId>
<version>${activiti-version}</version>
</dependency>
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-spring</artifactId>
<version>${activiti-version}</version>
</dependency>
<dependency>
<groupId>org.codehaus.groovy</groupId>
<artifactId>groovy-all</artifactId>
<version>2.4.3</version>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.3.168</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.6</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-jdk14</artifactId>
<version>1.7.6</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
</dependency>
其中activiti-version的定義如下：
<properties>
<activiti-version>5.18.0</activiti-version>
</properties>
其實這些內容我都是從Activiti工程的pom文件中拷貝過來的。
四、添加activiti需要的配置文件
在activiti的userguide（http://activiti.org/userguide/index.html#_configuration ）中有說。
如果我們使用如下語句來創建一個流程引擎實例
ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine()
那麼實際上他是到該項目的classpath路徑下去找一個名為
activiti.cfg.xml的配置文件，然後根據該配置文件的設置，通過spring的方式來創建一個processEngine。而且是去找其中
的那個名字是default的processEngine。
所以我們可以在該項目的src/main/resources 目錄下創建一個名為 activiti.cfg.xml的文件，然後將如下內容復制進去。
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd">
<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.">
</bean>
</beans>
五、創建sql server資料庫
通過sql server management studio 創建一個資料庫，比如名字叫做 activiti
六、在maven中添加sql server jdbc依賴項
在maven倉庫中是沒有sql server 的jdbc jar包的，可以按照如下步驟操作
Download the JDBC driver for Microsoft SQL Server
Visit the MSDN site for SQL Server and download the latest version of the JDBC driver for your operating system.
Unzip the package
Open a command prompt and switch into the expanded directory where the jar file is located.
Execute the following command. Be sure to modify the jar file name and version as necessary:
1
mvn install:install-file -Dfile=sqljdbc4.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0
You should see something similar to this:
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Maven Stub Project (No POM) 1
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-install-plugin:2.3.1:install-file (default-cli) @ standalone-pom ---
[INFO] Installing /Users/claude/installers/JDBC/sqljdbc_4.0/enu/sqljdbc4.jar to /Users/claude/.m2/repository/com/microsoft/sqlserver/sqljdbc4/4.0/sqljdbc4-4.0.jar
[INFO] Installing /var/folders/c6//T/mvninstall1874482299687761721.pom to /Users/claude/.m2/repository/com/microsoft/sqlserver/sqljdbc4/4.0/sqljdbc4-4.0.pom
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1.208s
[INFO] Finished at: Tue Mar 13 14:07:31 EDT 2012
[INFO] Final Memory: 3M/81M
[INFO] ------------------------------------------------------------------------
Modify your POM
Include the new dependency by modifying your project』s pom.xml. Add the following dependency:
1
2
3
4
5
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
Save the pom.xml file and build the project to make sure no errors exist.
七、讓activiti連接sql server資料庫
修改第四節中的activiti.cfg.xml文件，將 processEngineConfiguration的內容改成下文這樣：
<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.">
<property name="databaseSchemaUpdate" value="true"/>
<property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=activiti2 " />
<property name="jdbcDriver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="jdbcUsername" value="sa" />
<property name="jdbcPassword" value="sa123" />
</bean>
八、在代碼中使用activiti的api
ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
if(processEngine != null)
{
out.println("<h1> Hello !" + processEngine.getName() + "</h1>");
IdentityService identityService = processEngine.getIdentityService();
List<String> keys = identityService.getUserInfoKeys("Kermit");
for(String key: keys)
{
out.println(String.format("<h1> key = %s, value = %s </h1>", key, identityService.getUserInfo("Kermit", key)));
}
}
以上在調用 ProcessEngines.getDefaultProcessEngine(); 的時候，實際上背後就會去調用搜索classPath目錄下的activiti.cfg.xml文件，然後通過其中的配置來創建processEngine對象。
九、在eclipse中調試activiti項目
在eclipse中調試web項目，其實他是把相關的資料生成到如下路徑：
<eclipse workspace dir>\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\MavenWeb
如果發現某項配置修改之後，調試的時候沒有生效，那可以試著clean一下， Project ->clean...，然後重新生成即可。
『肆』 學sql2005,什麼書最好。
建議看看這個寶典，講得很全：
SQL Server 2005寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=149644
還有其他的，你也可以找一下：
SQL語言，資料庫基礎電子資料：
SQL語法大全中文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148128
SQL語言案頭完全參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146159
SQL - A Practical Introction
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148095
O'Reilly SQL Tuning
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159156
O'Reilly The Art of SQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163611
資料庫綜合資料庫
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146238
資料庫設計指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148082
Wrox Beginning Database Design
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145206
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
SQL Queries for Mere Mortals
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162978
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
Apress出版 The Berkeley DB Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=168290
The Handbook of Data Mining
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=176600
資料庫系統概論 浙江大學張軍教授主講(全32講)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154299
MS SQL Server電子資料：
Transact-SQL Cookbook
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163150
SQL Server 2005寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=149644
零基礎學SQL Server 2005電子教程+隨書光碟
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=181031
Microsoft SQL Server 2005完全參考
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152872
O'Reilly Learning SQL on SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163464
Beginning SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=153216
Pro SQL Server 2005 High Availability
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162981
Beginning SQL Server 2005 Administration
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152863
SQL Server 2005 Management and Administration
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=176845
SQL Server 2005 Unleashed
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152874
Pro SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152325
A Developer's Guide to SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145565
Pro T-SQL 2005 Programmer's Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154245
Beginning Transact-SQL with SQL Server 2000 and 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152868
SQL Server 2005報表服務
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148376
Wrox Professional SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151270
Scaling Out SQL Server 2005權威指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162785
Sql Server 2005 Performance Optimiztion and Tuning Handbood
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165048
Microsoft SQL Server 2005編程傻瓜書
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152864
Pro SQL Server 2005 Assemblies
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151269
MS SQL Server 2005 Reporting Essentials
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147862
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005管理員手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152347
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005數據挖掘
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148099
Pro SQL Server 2005 Service Broker
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159656
Pro SQL Server 2005 Replication
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160606
Sql server 2005的XML最佳實施策略
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152278
Microsoft SQL Server Black Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163457
MS SQL Server2000 寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145853
SQL Server 2000存儲過程和XML編程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152873
SQL Server 2005高級數據分析視頻教程系列
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162737
SQL Server 2005盛宴系列視頻 全52講
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151642
MySQL電子資料：
MySQL寶典
http://bbs.topsage.com/dispbbs_122_159157_1.html
SQL for MySQL Developers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152862
MySQL教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146824
Teach Yourself MySQL in 10 Minutes
http://bbs.topsage.com/dispbbs_122_174432_1.html
O'Reilly MySQL Pocket Reference 第二版 PDF
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL 5 權威指南(第三版)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148867
MySQL培訓經典教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146795
MySQL Cookbook 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175972
The Definitive Guide to MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175382
O'Reilly MySQL Pocket Reference 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL Essential Skills
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146749
MySQL Administrators Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146580
MySQL權威指南 中文版+英文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148870
MySQL 4.1.0 中文參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148869
MySQL in a Nutshell
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148868
Export MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152865
MySQL and PHP from Scratch
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152162
『伍』 sql中設置為decimal(18, 6) 下面只能保留整數 求保留兩位小數該怎麼改啊
使用如下語句試試：
string.Fomart("{0:F2}",dtList.Rows[k]["零售價"].ToString())
即<%=string.Fomart("{0:F2}",dtList.Rows[k]["零售價"].ToString()) %>
或者：<%=dtList.Rows[k]["零售價"].ToString("F2") %>
『陸』 SQL該怎麼用
SQL語言，資料庫基礎電子資料：
SQL語法大全中文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148128
SQL語言案頭完全參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146159
SQL - A Practical Introction
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148095
O'Reilly SQL Tuning
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159156
O'Reilly The Art of SQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163611
資料庫綜合資料庫
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146238
資料庫設計指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148082
Wrox Beginning Database Design
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145206
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
SQL Queries for Mere Mortals
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162978
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
Apress出版 The Berkeley DB Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=168290
資料庫系統概論 浙江大學張軍教授主講(全32講)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154299
MS SQL Server電子資料：
Transact-SQL Cookbook
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163150
SQL Server 2005寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=149644
Microsoft SQL Server 2005完全參考
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152872
O'Reilly Learning SQL on SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163464
Beginning SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=153216
Pro SQL Server 2005 High Availability
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162981
Beginning SQL Server 2005 Administration
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152863
SQL Server 2005 Unleashed
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152874
Pro SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152325
A Developer's Guide to SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145565
Pro T-SQL 2005 Programmer's Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154245
Beginning Transact-SQL with SQL Server 2000 and 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152868
SQL Server 2005報表服務
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148376
Wrox Professional SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151270
Scaling Out SQL Server 2005權威指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162785
Sql Server 2005 Performance Optimiztion and Tuning Handbood
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165048
Microsoft SQL Server 2005編程傻瓜書
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152864
Pro SQL Server 2005 Assemblies
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151269
MS SQL Server 2005 Reporting Essentials
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147862
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005管理員手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152347
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005數據挖掘
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148099
Pro SQL Server 2005 Service Broker
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159656
Pro SQL Server 2005 Replication
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160606
Sql server 2005的XML最佳實施策略
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152278
Microsoft SQL Server Black Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163457
MS SQL Server2000 寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145853
SQL Server 2000存儲過程和XML編程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152873
SQL Server 2005高級數據分析視頻教程系列
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162737
SQL Server 2005盛宴系列視頻 全52講
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151642
MySQL電子資料：
MySQL寶典
http://bbs.topsage.com/dispbbs_122_159157_1.html
SQL for MySQL Developers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152862
MySQL教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146824
Teach Yourself MySQL in 10 Minutes
http://bbs.topsage.com/dispbbs_122_174432_1.html
O'Reilly MySQL Pocket Reference 第二版 PDF
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL 5 權威指南(第三版)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148867
MySQL培訓經典教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146795
MySQL Cookbook 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175972
The Definitive Guide to MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175382
O'Reilly MySQL Pocket Reference 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL Essential Skills
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146749
MySQL Administrators Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146580
MySQL權威指南 中文版+英文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148870
MySQL 4.1.0 中文參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148869
MySQL in a Nutshell
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148868
Export MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152865
MySQL and PHP from Scratch
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152162
其他資料庫電子資料：
SQLite權威指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146072
Microsoft Access 2007初學者指南 2007年6月
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147856
Microsoft Access 2007寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=157078
Microsoft Office Access 2007 VBA寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=157113
Wrox出版 Expert Access 2007 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165951
Access 2007 窗體、報表和查詢
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160519
Microsoft Acces 2007數據分析
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160656
Oracle Automatic Storage Management
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=166808
Pro Oracle Spatial for Oracle Database 11g
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165942
Oracle 9i 資料庫管理員指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146230
Wrox Professional Oracle 8i Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163479
O'Reilly Oracle Security
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160137
PL/SQL Study Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148096
Sybase實用教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146235
PostgreSQL 對象關系資料庫開發
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159286
PostgreSQL 必備參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159298
PostgreSQL 7 資料庫開發指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159302
PostgreSQL 8 for Windows 2007年3月最新出版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159310
Crystal Reports 10 完全參考
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147099
Crystal Reports 10 水晶報表10傻瓜書
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=156454
『柒』 求教sql語句問題
我運行了，沒有問題的
這兩個語言你都選擇上再點「運行」
要麼就不要選擇任何一句
SQL語言，資料庫基礎電子資料：
SQL語法大全中文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148128
SQL語言案頭完全參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146159
SQL - A Practical Introction
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148095
O'Reilly SQL Tuning
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159156
O'Reilly The Art of SQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163611
資料庫綜合資料庫
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146238
資料庫設計指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148082
Wrox Beginning Database Design
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145206
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
SQL Queries for Mere Mortals
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162978
SQL Puzzles and Answers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160834
Apress出版 The Berkeley DB Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=168290
資料庫系統概論 浙江大學張軍教授主講(全32講)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154299
MS SQL Server電子資料：
Transact-SQL Cookbook
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163150
SQL Server 2005寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=149644
Microsoft SQL Server 2005完全參考
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152872
O'Reilly Learning SQL on SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163464
Beginning SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=153216
Pro SQL Server 2005 High Availability
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162981
Beginning SQL Server 2005 Administration
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152863
SQL Server 2005 Unleashed
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152874
Pro SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152325
A Developer's Guide to SQL Server 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145565
Pro T-SQL 2005 Programmer's Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=154245
Beginning Transact-SQL with SQL Server 2000 and 2005
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152868
SQL Server 2005報表服務
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148376
Wrox Professional SQL Server 2005 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151270
Scaling Out SQL Server 2005權威指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162785
Sql Server 2005 Performance Optimiztion and Tuning Handbood
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165048
Microsoft SQL Server 2005編程傻瓜書
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152864
Pro SQL Server 2005 Assemblies
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151269
MS SQL Server 2005 Reporting Essentials
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147862
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005管理員手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152347
SQL Server 2005工具箱內幕
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152321
SQL Server 2005數據挖掘
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148099
Pro SQL Server 2005 Service Broker
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159656
Pro SQL Server 2005 Replication
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160606
Sql server 2005的XML最佳實施策略
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152278
Microsoft SQL Server Black Book
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163457
MS SQL Server2000 寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=145853
SQL Server 2000存儲過程和XML編程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152873
SQL Server 2005高級數據分析視頻教程系列
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=162737
SQL Server 2005盛宴系列視頻 全52講
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=151642
MySQL電子資料：
MySQL寶典
http://bbs.topsage.com/dispbbs_122_159157_1.html
SQL for MySQL Developers
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152862
MySQL教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146824
Teach Yourself MySQL in 10 Minutes
http://bbs.topsage.com/dispbbs_122_174432_1.html
O'Reilly MySQL Pocket Reference 第二版 PDF
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL 5 權威指南(第三版)
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148867
MySQL培訓經典教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146795
MySQL Cookbook 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175972
The Definitive Guide to MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175382
O'Reilly MySQL Pocket Reference 第二版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=175014
MySQL Essential Skills
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146749
MySQL Administrators Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146580
MySQL權威指南 中文版+英文版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148870
MySQL 4.1.0 中文參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148869
MySQL in a Nutshell
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148868
Export MySQL
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152865
MySQL and PHP from Scratch
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=152162
其他資料庫電子資料：
SQLite權威指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146072
Microsoft Access 2007初學者指南 2007年6月
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147856
Microsoft Access 2007寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=157078
Microsoft Office Access 2007 VBA寶典
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=157113
Wrox出版 Expert Access 2007 Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165951
Access 2007 窗體、報表和查詢
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160519
Microsoft Acces 2007數據分析
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160656
Oracle Automatic Storage Management
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=166808
Pro Oracle Spatial for Oracle Database 11g
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=165942
Oracle 9i 資料庫管理員指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146230
Wrox Professional Oracle 8i Programming
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=163479
O'Reilly Oracle Security
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=160137
PL/SQL Study Guide
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=148096
Sybase實用教程
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=146235
PostgreSQL 對象關系資料庫開發
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159286
PostgreSQL 必備參考手冊
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159298
PostgreSQL 7 資料庫開發指南
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159302
PostgreSQL 8 for Windows 2007年3月最新出版
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=159310
Crystal Reports 10 完全參考
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=147099
Crystal Reports 10 水晶報表10傻瓜書
http://bbs.topsage.com/dispbbs.asp?boardID=122&ID=156454