sqlserver 分页查询

declare @PageSize int,@PageIndex int

set @PageSize=10

set @PageIndex=1

select top(@PageSize) * from (select row_number() over(order by (select 1)) row,* from Order_list) t

where t.row > @PageSize*(@PageIndex-1)

--sqlserver 生成日期列表

SELECT
    CONVERT (VARCHAR (100),dateadd(d, number, GETDATE() + 1 - 7),23) AS 日期
FROM
    master..spt_values n
WHERE
    n.type = 'p'
AND n.number <= 7;

--sql server 查询当前月份日期列表数据
 
SELECT
CONVERT (VARCHAR (10), dateadd(dd,number, dateadd(dd,-day(getdate())+1,getdate())),120) AS every_time, --日期
datepart(weekday, dateadd(dd,number, dateadd(dd,-day(getdate())+1,getdate())) ) AS Weekd --星期几
FROM
master..spt_values n
WHERE
n.type = 'p' 
and number<datediff(day,dateadd(dd,-day(getdate())+1,getdate()),dateadd(mm,+1,dateadd(dd,-day(getdate())+1,getdate())))