sql´æ´¢

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