sqlserver2010分页查询,sqlserver通用型分页
sqlserver2010分页查询,sqlserver通用型分页
分页查询(通用型)
select top pageSize * from student where sNo>=(select max(sNo) from (select top ((pageIndex-1)*pageSize 1) sNofrom student order by sNo asc) temp_max_ids) order by sNo;
为DataTable对象特定的单元格赋值