摘要： 写很复杂的存储过程也许效率可能是高一点,但是很复杂,下面是很简单但效率也不错的分页方法: set @ = 'select * from (select Top ' + cast(@Size as varchar(100)) + ' * from (select Top ' + cast((@Page * @Size) as varchar(100)) + ' * from produ... 阅读全文