mssql 创建存储过程简单实例

复制代码
CREATE procedure [dbo].[cp_User_Increment]
    @channelId int,
    @currentPage int,
    @pageSize int,
    @userId int
as

if @channelId<=0
    begin
        select 
        CurrentTime,
        Count
        from
        (
            select 
            *,
            ROW_NUMBER() OVER(ORDER BY CurrentTime DESC) AS RowNum 
            from 
            (
                select 
                CONVERT(varchar(12), AddTime, 111 ) as CurrentTime,
                COUNT(1) as Count 
                from Users 
                where IsDel=0 and ChannelId in (select ChannelId from Channel_User where UserId=@userId)
                group by CONVERT(varchar(12), AddTime, 111) 
            )a 
        )b
        where RowNum BETWEEN (@currentPage-1)*@pageSize+1 and @currentPage*@pageSize
    end
else
    begin
    
        select 
        CurrentTime,
        Count
        from
        (
            select 
            *,
            ROW_NUMBER() OVER(ORDER BY CurrentTime DESC) AS RowNum 
            from 
            (
                select 
                CONVERT(varchar(12), AddTime, 111 ) as CurrentTime,
                COUNT(1) as Count 
                from Users
                where IsDel=0 and ChannelId=@channelId and ChannelId in (select ChannelId from Channel_User where UserId=@userId)
                group by CONVERT(varchar(12), AddTime, 111) 
            )a 
        )b
        where RowNum BETWEEN (@currentPage-1)*@pageSize+1 and @currentPage*@pageSize
    end

GO
复制代码

 

posted @   大空白纸  阅读(988)  评论(1编辑  收藏  举报
编辑推荐:
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
阅读排行:
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
历史上的今天:
2015-06-01 asp.net mvc url应用
点击右上角即可分享
微信分享提示