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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tiku_koushi]') and OBJECTPROPERTY (id, N'IsUserTable') = 1) drop table [dbo].[tiku_koushi] GO CREATE TABLE [dbo].[tiku_koushi] ( [id] [int] IDENTITY (1, 1) NOT NULL , [title] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [list2_id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO

CREATE proc sp_c @tablename varchar(50), @title varchar(250), @list2_id varchar(50) as if @tablename='tiku_koushi' select count(*) from tiku_koushi where title like '%'+@title+'%' and list2_id=@list2_id GO