正在阅读：asp 用存储过程实现数据分页asp 用存储过程实现数据分页

CREATE PROCEDURE sp_search_tiku @tablename varchar(50), @title varchar(250), @list2_id varchar(10), @pagesize int, @page int AS if @tablename='tiku_koushi' begin declare @ks int declare @str varchar(200) set @ks=@pagesize*(@page-1) if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp_table91]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin select * into temp_table91 from tiku_koushi where title like '%'+@title+'%' and list2_id=@list2_id order by id desc set rowcount @pagesize set @str='select * from temp_table91 where id not in (select top '+str(@ks)+' id from temp_table91)' execute(@str) drop table temp_table91 end end GO