MSSQL 存储过程分页测试 3

最新推荐文章于 2025-12-15 10:09:52 发布

原创最新推荐文章于 2025-12-15 10:09:52 发布 · 767 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#测试 #存储 #user #go

MSSQL 专栏收录该内容

4 篇文章

订阅专栏

博客展示了一段SQL代码，用于实现分页查询。代码中定义了用户条件、排序、排名等变量，根据不同的页面顺序和排名规则生成相应的SQL查询语句，最后执行查询，涉及SQL语言的运用。

DECLARE @User_Condition varchar(500)
DECLARE @User_Sort varchar(20)
DECLARE @User_Rank varchar(4)

DECLARE @Page_Size real
DECLARE @Page_Order int
DECLARE @SQLQuery varchar(1000)

Set @Page_Size = 10
Set @Page_Order = 1

Set @User_Sort = 'Digitaltion_ID'
Set @User_Rank = 'Desc'

IF (@Page_Order > 0)
IF (@User_Rank = 'Asc')
    BEGIN
      Set @SQLQuery = 'SELECT TOP '+ STR(@Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] WHERE (Digitaltion_ID > (SELECT MAX(Digitaltion_ID) FROM (SELECT TOP '+ STR(@Page_Order * @Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] ORDER BY '+ @User_Sort +' Asc) AS TeamTable)) ORDER BY '+ @User_Sort +' Asc'
    END
Else
    BEGIN
      Set @SQLQuery = 'SELECT TOP '+ STR(@Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] WHERE (Digitaltion_ID < (SELECT MIN(Digitaltion_ID) FROM (SELECT TOP '+ STR(@Page_Order * @Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] ORDER BY '+ @User_Sort +' Desc) AS TeamTable)) ORDER BY '+ @User_Sort +' Desc'
    END
Else
IF (@User_Rank = 'Asc')
    BEGIN
      Set @SQLQuery = 'SELECT TOP '+ STR(@Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] ORDER BY '+ @User_Sort +' Asc'
    END
Else
    BEGIN
      Set @SQLQuery = 'SELECT TOP '+ STR(@Page_Size) +' Digitaltion_ID FROM [DigitalART_Digitaltion] ORDER BY '+ @User_Sort +' Desc'
    END