摘要:
ALTER procedure [dbo].[分页]@pageSize int,@pageOrder int,@searchTable NVARCHAR(200),@pageAmount INT OUTPUTASBEGIN DECLARE @STR NVARCHAR(MAX) SET @STR = ' set @pageAmount =(select COUNT(*)/@pageSize from @searchTable) select top (@pageSize) * from @searchTable where fid not in ( select top (@pageSi 阅读全文