06 2012 档案

摘要:须为标识列,[ID] int IDENTITY (1,1) 1.分页方案一:(利用Not In和SELECT TOP分页)语句形式: SELECT TOP 10 *FROM TestTableWHERE (ID NOT IN (SELECT TOP 20 id FROM TestTable ORDER BY id))ORDER BY IDSELECT TOP 页大小 *FROM TestTableWHERE (ID NOT IN (SELECT TOP 页大小*页数 id FROM 表 ORDER BY id))ORDER BY ID 2.分页方案二:(... 阅读全文
posted @ 2012-06-13 21:32 】Richard【 阅读(172) 评论(0) 推荐(0)
摘要:.net注册机制案例----------------------------------------------------using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.ComponentModel;namespace JasonTest{ class Program { static void Main(string[] args) { try { TestWorker testWorker = new TestWorker(args); // 实. 阅读全文
posted @ 2012-06-06 15:53 】Richard【 阅读(220) 评论(0) 推荐(0)