1、执行返回数据列表型
CREATE PROCEDURE [dbo].[SP_ManageForumGroupsPostRecycle]
CREATE PROCEDURE [dbo].[SP_ManageForumGroupsPostRecycle]
@userId VARCHAR(128), --用户ID
AS
BEGIN
SET NOCOUNT ON;
DECLARE @rowId INT
SET @rowId=( @page - 1 ) * @pageSize;
----列表数据
SELECT
G.Id,P.Title,G.PostId,A.NikeName,G.CreateDate,G.Note FROM GroupsPostRecycle AS G
LEFT JOIN dbo.GroupsPost AS P ON g.PostId=p.Id
LEFT JOIN HTUser.dbo.AspNetUsers AS A ON A.Id=G.UserId
WHERE 1=1 And