上一页 1 ··· 3 4 5 6 7
摘要: 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 阅读全文
posted @ 2012-07-14 14:25 美丽的矩阵 阅读(146) 评论(0) 推荐(0) 编辑
上一页 1 ··· 3 4 5 6 7