rework SQL Server

static Connecttion String

connection string 放到 using內讓每個 method自己去拉,  不要放到最外層設成 static

T-SQL 分頁查詢

SELECT TOP <page size> * 
FROM ( 
    SELECT 
        ROW_NUMBER() OVER(ORDER BY CaseId DESC) AS Row 
        , CaseId, CaseNo, CaseName
    FROM dbo.CaseManage 
    WHERE Creator=@UserId 
) Result WHERE ROW > (<page size>*(<page index>-1)) 
ORDER BY CreateTime DESC;

SQL Server 2005 插入多筆資料

 SQL Server 2005

同時插入多筆資料不能寫在同一句 query內

ex:

INSERT INTO [table]
([field1], [field2], [field3])
VALUES
(@fieldA1, @fieldA2, @fieldA3), (@fieldB1, @fieldB2, @fieldB3)

Win Server 2003 R2 + SQL Server 2008 安裝

需先安裝 .NET Framework 3.5 SP1

Features：

• Instance Features
• Database Engine Services
• SQL Server Replication
• Full-text Search

要做分析及報表再勾選 Analysis Services、Reporting Services


• Shared Features
• Integration Services
• Management Tool - Basic
• Management Tool - Compelete

Server 2003 SP2 安裝 SQL Server 2008 失敗的解決方法
裡面提及若是已經安裝 MS XML 6 SP2，會導致 SQL Server 2008安裝失敗
可以先刪除後再用 Windows Update安裝