本过程用于分页
select identity(int,1,1)TID,NAME,sortcode,publisher,writer into #Temp321 from BOOKINFO where 参数1SELECT TOP 10 *
FROM #Temp321
WHERE (TID >=
(SELECT MAX(TID)
FROM (SELECT TOP 参数2 TID
FROM #Temp321
ORDER BY TID) AS T))
ORDER BY TID
select identity(int,1,1)TID,NAME,sortcode,publisher,writer into #Temp321 from BOOKINFO where 参数1SELECT TOP 10 *
FROM #Temp321
WHERE (TID >=
(SELECT MAX(TID)
FROM (SELECT TOP 参数2 TID
FROM #Temp321
ORDER BY TID) AS T))
ORDER BY TID
@参数1 varchar(10000),
@参数2 int
asexec('
select identity(int,1,1)TID,NAME,sortcode,publisher,writer into #Temp321 from BOOKINFO where ' + @参数1 + '
SELECT TOP 10 *
FROM #Temp321
WHERE (TID >=
(SELECT MAX(TID)
FROM (SELECT TOP ' + @参数2 +' TID
FROM #Temp321
ORDER BY TID) AS T))
ORDER BY TID
')
as
begin
exec('select identity(int,1,1)TID,NAME,sortcode,publisher,writer into Temp321 from BOOKINFO where '+@p1)exec('SELECT TOP 10 *
FROM Temp321
WHERE (TID >=
(SELECT MAX(TID)
FROM (SELECT TOP '+rtrim(p2)+' TID
FROM Temp321
ORDER BY TID) AS T))
ORDER BY TID')
end