- 博客(2)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 给当前页或者跳转后页面的导航栏添加选中样式
$("ul.nav-list li a").each(function () { //$("ul.nav-list li").removeClass("active"); if ($($(this))[0].href == String(window.location)) if ($(this).parent().find("li...
2017-07-14 13:44:00
106
原创 老司机出招： 程序员如何写简历和面试？
作者：Seaborn Lee 我求职面试的经验不多，在创业期间，倒是积累了一些招聘面试的经验。 面试，相亲，销售的过程都很类似，抽象一下，它们的本质是什么？我认为是： 展示自我和挖掘对方需求的过程。 一、简历 为什么要写简历？ 如果有人要给你介绍对象，你是直接约见面呢还是先看一下Ta的简介？你当然也不希望刚一见面就发现对方不是你的菜，既浪...
2017-07-04 11:31:00
176
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
2009-05-08
sql 2000自定义分页存储过程
CREATE PROCEDURE [dbo].[pro_Pager]
@TableName varchar(50),
@Condition nvarchar(500),
@Fields varchar(500),
@CurrentPage int,
@PageSize int,
@OrderField varchar(100),
@OrderType varchar(4)
AS
set nocount on
declare @SQL nvarchar(2000)
if @OrderType = 'Desc'
begin
if @Condition = 'None'
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' desc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc'
end
end
else
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc'
end
end
end
else
begin
if @Condition = 'None'
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' asc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' asc) temp) order by ' + @OrderField + ' asc'
end
end
else
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc] temp) order by ' + @OrderField + ' asc'
end
end
end
exec sp_executesql @SQL
2008-12-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人