rework SQL Server

SQL Server 2005 無法做子查詢

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)