模板
教程
環境
性能
功能
管理
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
