@PageCount int OUTPUT --总页数
IF @PageCount IS NULL BEGIN SET @sql=N'SELECT @PageCount=COUNT(*)' +N' FROM '+@tbname +N' '+@Where EXEC sp_executesql @sql,N'@PageCount int OUTPUT',@PageCount OUTPUT SET @PageCount=(@PageCount+@PageSize-1)/@PageSize END
posted on 2017-11-28 18:46
sanmao 阅读(247)
评论(0) 编辑 收藏