ASP.NET List.Find() with delegate

list.Find(delegate(NavigatorData nvg) { return nvg.name == "Tags"; });

SQL TRUNCATE TABLE [...]

跟 DELETE一樣  刪除資料

無法設 WHERE條件, 整張表清空
但是不保留紀錄、自動編號重設

有被 FOREIGN KEY條件限制時, 不可使用 

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;