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.分页方案二:(...
阅读全文
摘要:.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); // 实.
阅读全文

浙公网安备 33010602011771号