摘要：
1）NOT INdeclare @timediff datetimedeclare @pageIndex intdeclare @pageSize intdeclare @sql varchar(500)set @pageIndex=1set @pageSize=10set @timediff=GetDATE()set @sql='select top ('+cast(@pageSize as varchar)+') * from testTable where (id not in (select top '+cast(@pageSize*(@pageInde 阅读全文
