declare @p int
declare @p1 int
declare @count int
set @p=0
set @p1=10
set @count=2
if(@count<>0 or @count<>1)
set @p=@p1*@count-10
SELECT [t1].[userid], [t1].[username], [t1].[userorder]
from (
SELECT ROW_NUMBER() OVER (ORDER BY [t0].[userorder]) AS [ROW_NUMBER], [t0].[userid], [t0].[username], [t0].[userorder]
from [dbo].[users] AS [t0]
) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN @p + 1 AND @p + @p1
USE [SC1]
GO
/****** Object: StoredProcedure [dbo].[KB_ExaminationSearch_sp] Script Date: 05/17/2010 08:55:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <peter>
-- Create date: <2010-03-15>
-- Description: <获取发布考试信息>
-- =============================================
ALTER PROCEDURE [dbo].[KB_ExaminationSearch_sp]
@papecode NVARCHAR(10),
@BExamdate NVARCHAR(50),
@EExamdate NVARCHAR(50),
@usercode NVARCHAR(50),
@subccode NVARCHAR(10),
@examstae NVARCHAR(50),
@deptcode NVARCHAR(50),
@BExamscor NVARCHAR(10),
@EExamscor NVARCHAR(10),
@PageIndex INT,
@PageSize INT,
@RecordCount INT OUTPUT
AS
BEGIN
DECLARE @sql NVARCHAR(4000)
DECLARE @fromWhere NVARCHAR(3500)
SET @fromWhere = ' from(SELECT CASE examstat WHEN ''0'' THEN ''未发布'' WHEN ''1'' THEN ''已发布'' WHEN ''2'' THEN ''待批阅'' WHEN ''3'' THEN ''已批阅'' WHEN ''4'' THEN ''完成'' WHEN ''6'' THEN ''考试中'' WHEN ''7'' THEN ''待考'' ELSE ''缺考'' END examstae,kbexam.*,kbpape.papname,aduser.userenam,subccode from PKKBEXAMM0 kbexam LEFT JOIN PKKBPAPEM0 kbpape ON kbexam.papecode = kbpape.papecode LEFT JOIN PKADUSERM0 aduser ON aduser.usercode = kbexam.usercode)temp WHERE 1 = 1 '
IF(@usercode
