分页使用SQL服务器，参数错误 [英] Pagination using SQL server ,parameter error

问题描述

Hi,

CREATE PROCEDURE [dbo].[spStudentListPagination] 
    
     @start int = 0,
     @pageCount int=0

AS
BEGIN
   
     Set NOCOUNT ON
     SELECT TOP @pageCount * FROM 
     (
          SELECT 
       [STNO]
      ,[SNAME]
      ,[MAJOR]
      ,[CLASS]
      ,[BDATE]
      , ROW_NUMBER() OVER (ORDER BY STNO) AS num
      FROM [student_db].[dbo].[Student]
     ) AS a
     WHERE num > @start
END

产生错误

it generating the error

Msg 102, Level 15, State 1, Procedure spStudentListPagination, Line 9
Incorrect syntax near ''@pageCount''.
Msg 156, Level 15, State 1, Procedure spStudentListPagination, Line 19
Incorrect syntax near the keyword ''AS''.

当我给@start和@pagecount提供直接值时结果是正确选择表数据..

when i am giving the direct value to @start and @pagecount The result is selecting the table data properly..

推荐答案

嗨基督徒，



尝试一下。

Hi Christian,

Try it out .

  CREATE PROCEDURE GetBranchesnyPage 
    
     @start int = 0,
     @pageCount int=0
 
AS
BEGIN
   
    
     Set NOCOUNT ON
     SELECT  * FROM 
     (
          SELECT 
       [Id]
      ,[BranchName]
      ,[CountryCode] 
      , ROW_NUMBER() OVER (ORDER BY Id) AS num
      FROM Branches
     ) AS A
     WHERE num > @start and num <=(@start+@pageCount)
END

我希望它可以帮助你


最好的

I hope it can help you

All the best

SQL Server不支持此功能。遗憾的是，您需要创建一行SQL并使用EXEC来执行此操作。

SQL Server does not support this. Sadly, you need to create a line of SQL and use EXEC, to do this.

这篇关于分页使用SQL服务器，参数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！