將Tomcat加到Windows服務中

%TOMCAT_HOME%\bin\service install

ex: C:\Program Files\Apache Group\apache-tomcat-6.0.26\bin\service install

右鍵選單中新增選項

在右鍵選單中新增"以記事本開啟"選項：
1. 「開始」->「執行」-> "regedit"。
2. HKEY_CLASSES_ROOT -> * -> Shell 。在其下新增 "以記事本開啟"(按右鍵後選單中顯示的文字) 機碼，然後在 Notepad 機碼之下再新增 Command 機碼。
3. 在Command 之下，請將(預設值)之「數值資料」修改為"notepad %1"。

Word 2003 標點符號無法於文章中使用

Word 2003 在編輯中時，於標點符號工具列中可點選標點符號按鈕，但文章中完全沒有反應。

解決方式：
1、關閉word
2、[開始] -> [執行]，輸入cmd，按[Enter]；開啟命令提示字元。
3、確定Word安裝的目錄，office1X
3、在視窗中輸入cd C:\program files\microsoft Office\office11\addins，完成後按[enter]鍵
4、輸入regsvr32 /u SYMINPUT.DLL 完成後，按下[Enter]鍵
5、輸入regsvr32 SYMINPUT.DLL 完成後，按下[Enter]鍵
6、開啟word後即可使用

Sum

-------
Select OrderID,ProductID,UnitPrice*Quantity*(1-Discount) as '小計'
from dbo.[Order Details]

-------
Select Convert(int,Sum(UnitPrice*Quantity*(1-Discount))) as '訂單總金額'
from dbo.[Order Details]

----
Select YEAR(OrderDate) as '年度' ,
Convert(int,Sum(UnitPrice*Quantity*(1-Discount))) as '訂單總金額'
from dbo.Orders O join dbo.[Order Details] D on O.OrderID=D.OrderID
GROUP BY YEAR(OrderDate)

------
Select YEAR(OrderDate) as '年度' ,Datepart(Quarter,OrderDate) as '季' ,
Convert(int,Sum(UnitPrice*Quantity*(1-Discount))) as '訂單總金額' ,
Count(distinct O.OrderID) as '訂單總筆數'
from dbo.Orders O join dbo.[Order Details] D on O.OrderID=D.OrderID
GROUP BY YEAR(OrderDate),Datepart(Quarter,OrderDate)
Order BY YEAR(OrderDate),Datepart(Quarter,OrderDate)

Count

use Northwind;

-----------------
Select*
from dbo.Orders

-----
Select Count(*) as '訂單總筆數'
from dbo.Orders

----
Select Count(ShippedDate) as '已出貨總筆數'
from dbo.Orders

Select YEAR(OrderDate) as '年度',Count(*) as '訂單總筆數'
from dbo.Orders
Group by YEAR(OrderDate)

------
Select YEAR(OrderDate) as '年度',Datepart(Quarter,OrderDate) as '季',Count(*) as '訂單總筆數'
from dbo.Orders
GROUP BY YEAR(OrderDate),Datepart(Quarter,OrderDate)
Order BY YEAR(OrderDate),Datepart(Quarter,OrderDate)

---return bigint(ver.2005)
Select Count_BIG(*) as '訂單總筆數'
from dbo.Orders

Except

--1997/1有下訂單但1997/2月無訂單的客戶
Select distinct CustomerID
from dbo.Orders
where year(OrderDate)=1997 and month(OrderDate)=1
except
Select distinct CustomerID
from dbo.Orders
where year(OrderDate)=1997 and month(OrderDate)=2

Intersect

/*
只包括 TABLE1 和 TABLE2 中都有的行並消除所有重複行而派生出一個結果表。當 ALL 隨 INTERSECT 一起使用時 (INTERSECT ALL)，不消除重複行。
*/

--1997/1及1997/2月均有下訂單的客戶
Select distinct CustomerID
from dbo.Orders
where year(OrderDate)=1997 and month(OrderDate)=1
intersect
Select distinct CustomerID
from dbo.Orders
where year(OrderDate)=1997 and month(OrderDate)=2