|
一、创建表 tiku_koushi
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 二、存储过程 sp_cCREATE 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 |
闂佽 鍋撻柟顖滃椤ユ垿鏌熺€涙ê濮囧┑顕嗘嫹闂佸搫琚崕鍐诧耿閸涙潙缁╅柟顖滃椤ワ拷>>
正在阅读：asp 用存储过程实现数据分页asp 用存储过程实现数据分页
2005-06-11 11:19
出处：
责任编辑：moningfeng
键盘也能翻页，试试“← →”键
