!!!!!!!!!!!这个问题不知道错在什么地方!!!!!!!!!!!!!!!!!!
exec QsqMessageHintSearch 10,1,'SELECT dbo.QsqMessageHint.*, Sender.UserID AS SenderID,
Sender.UserName AS SenderName, Getter.UserID AS GetterID,
Getter.UserName AS GetterName
FROM dbo.forums_Users Sender INNER JOIN
dbo.QsqMessageHint ON
Sender.UserID = dbo.QsqMessageHint.mhSenderUserId INNER JOIN
dbo.forums_Users Getter ON dbo.QsqMessageHint.mhUserId = Getter.UserID',0
服务器: 消息 213,级别 16,状态 7,行 1
插入错误: 列名或所提供值的数目与表定义不匹配。
alter PROC QsqMessageHintSearch
@pageSize INT=10,
@pageIndex INT=1,
@sql VARCHAR(500),
@count INT output
AS
CREATE TABLE #PageIndex
(
pageID int IDENTITY (1, 1) NOT NULL,
indexid int
)
begin
INSERT INTO #PageIndex (indexid)
EXEC (@sql)
end
SELECT dbo.QsqMessageHint.*, Sender.UserID AS SenderID,
Sender.UserName AS SenderName, Getter.UserID AS GetterID,
Getter.UserName AS GetterName
FROM dbo.forums_Users Sender INNER JOIN
dbo.QsqMessageHint ON
Sender.UserID = dbo.QsqMessageHint.mhSenderUserId INNER JOIN
dbo.forums_Users Getter ON dbo.QsqMessageHint.mhUserId = Getter.UserID m
INNER JOIN
(SELECT * FROM #PageIndex WHERE pageId>=@pageSize*(@pageIndex-1) AND pageId<=@pageSize*@pageIndex) p
ON QsqMessageHint.mhid=p.indexid
ORDER BY QsqMessageHint.mhid DESC
--取得总共数量
--DECLARE @count INT
SELECT @count=MAX(pageID) FROM #PageIndex
IF @count IS NULL
SELECT 0
ELSE
SELECT @count
DROP TABLE #PageIndex