⑴ tutorial D
這是我們大學老師開發的創建Database的軟體
⑵ 0.01一直加到0.99等於49.5
在高中，是等差數列求前n項的和。公式為S=n（a1+an）/2
這里，a1=0.01，an=0.99，n=99
S=99·（0.01+0.99）/2=49.5
可以用SQL Server Import and Export Wizard或者 SSIS 創建一個Data Flow Task 來實現。
具體步驟，參考一下鏈接：
http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/
http://www.mssqltips.com/sqlservertip/2684/importing-sql-server-data-using-ssis--which-option-is-fastest/
⑷ eclipe 報錯import="com.wxpn.tutorial.db.DB,
<%@ page
import="com.wxpn.tutorial.db.DB,com.wxpn.tutorial.db.ConnectionPool"
%>
<%@ page
import="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException"%>
這兩句改了
<%@ page import="com.wxpn.tutorial.db.DB;"%>
<%@ page import="om.wxpn.tutorial.db.ConnectionPool;"%>
<%@ page import="java.sql.Connection,java.sql.Statement;"%>
<%@ page import="java.sql.ResultSet;"%>
<%@ page import="java.sql.SQLException;"%>
⑸ 存儲過程tutorial是什麼意思
存儲過程（Stored Procere）是在大型資料庫系統中，一組為了完成特定功能的SQL 語句集，經編譯後存儲在資料庫中，用戶通過指定存儲過程的名字並給出參數（如果該存儲過程帶有參數）來執行它。存儲過程是資料庫中的一個重要對象，任何一個設計良好的資料庫應用程序都應該用到存儲過程。
⑹ 如何成為QTP專家
1. VBScript
QTP uses VBScript language. That's why strong knowledge of VBScript is 'must have'.
Sources:
w3schools' VBScript tutorial
MS' VBScript Guide.
2. Software Testing Automation Frameworks
To write good automated tests, you should know how to write them.
There are different approaches and solution. There is not a silver bullet.
Sources:
Test Automation Frameworks
Choosing a Test Automation Framework
Totally Data-Driven Automated Testing
Seven Steps to Test Automation Success
3. HP QuickTest Professional Tutorial
This QTP tutorial cames with QTP.
It's quite clean and informative. Its main goal is to show and explain basic concepts of QuickTest Professional. It provides knowledge on:
creating a test
working with Object Repository (OR)
running and analyzing tests
verifying tests
parameterizing, etc
Sources: '\help\QTTutorial.pdf' or '\help\Tutorial.chm' in QTP Install folder.
4. HP QuickTest Professional User's Guide
As previous tutorial, the present User's Guide come with QTP install too.
This guide is intended for QuickTest Professional users at all levels. It gives a deeper knowledge on:
working with QTP Object Repositoies
designing tests
enhancing tests (checkpoints, parameterizing, etc)
maintaining anf debugging tests
advanced testing features, etc
Sources: '\help\QTUsersGuide.pdf' or '\help\MainUsersGuide.chm' in QTP Install folder.
5. COM/DCOM Technologies
When working with QTP, you will be closely linked with such Microsoft's applications, as: Excel, Word, Outlook. So, I recommend to get familiar with COM, COM Technologies, and COM objects of:
MS Internet Explorer
MS Excel
MS Outlook
6. SQL
SQL is so important in programming, that I strongly recommend to spend time to learn SQL:
concepts of RDBM
selecting/updating/deleting data
SQL queries optimizations
databases administration
Sources:
w3schools' SQL tutorial
MS SQL Server - this and this
Oracle DB
7. XML
XML is an extremely popular and useful format. I'm sure that нou will have to deal with data, stored in XML-files.
Sources:
w3schools' XML tutorial
8. HTML, DOM
Since QuickTest Professional works perfectly with web applications, you should be expert in related fields - HTML, HTTP, DHTML, DOM, etc. They will simplify your future QTP script and make them more reliable and maintenable.
Sources:
w3schools' HTML tutorial
w3schools' DHTML tutorial
A Beginner's Guide to the XML DOM
DOM tutorials
9. HP QTP Knowledge Base
It contains a lot of practical articles about QuickTest Professional.
You can find there QTP webinars, QTP FAQs, documentations, solutions of your problems or different ways how to improve your QTP automated tests.
Sources:
HP Self-solve Knowledge Search (requires an access to HP site)
10. Useful sites
Sure, it's impossible to know all information on QTP.
That's why I recommend to use these two sites to search answers to your QTP questions:
Google
Easy way to automate testing
參考資料：http://www.cnblogs.com/txw1958/archive/2012/11/20/how-to-become-qtp-guru.html
⑺ sql2014如何將表導出
你可以使用SQL Server 自帶的功能：SQL Server 導入和導出向導。此功能為在數據源之間復制數據和構造基本包提供了一種最為簡單的方法。
參考鏈接：
https://msdn.microsoft.com/zh-cn/library/ms140052.aspx
https://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/
⑻ 誰有關於vb和sql的英文文獻（有書名，作者，年代，出版社就行）分數好商量
http://www.w3schools.com/sql/default.asp
SQL Tutorial(SQL 輔導)
http://www.vbtutor.net/vbtutor.html
VB Tutorial (VB 輔導)
希望能有所幫助，謝謝