模板
教程
环境
性能
功能
管理
asp 用存储过程实现数据分页
发表于：2007-06-30来源：作者：点击数：
标签：
一、创建表 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] IDE
一、创建表 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_c
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
