wangdaiyt,剑灵李素梅,杂志在线
一、创建表 tiku_koushi
if exists (select * from dbo.sysobjects where id =
object_id(n[dbo].[tiku_koushi]) and objectproperty
(id, nisusertable) = 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
三、存储过程 sp_search_tiku
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, nisusertable) = 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
本新闻共3页,当前在第1页 1 2 3
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Blazor server side 自家的一些开源的, 实用型项目的进度之 CEF客户端
.NET IoC模式依赖反转(DIP)、控制反转(Ioc)、依赖注入(DI)
vue+.netcore可支持业务代码扩展的开发框架 VOL.Vue 2.0版本发布
网友评论