Shulou(Shulou.com)06/01 Report--

ALTER procedure [dbo]. [PageSplit] @ sql varchar (max),-- sql statement to be executed @ page int=1,-- Page number to be displayed @ pageSize int,-- Total number of pages @ pageCount int=0 out,-- @ recordCount int=0 out-- Total number of records asset nocount ondeclare @ p1 INTexec sp_cursoropen @ p1 output,@sql,@scrollopt=1,@ccopt=1 @ rowcount=@pagecount outputset @ recordCount = @ pageCountselect @ pagecount=ceiling (1.0*@pagecount/@pagesize) if @ page > @ pagecountselect @ page= @ pagecountselect @ page= (@ page-1) * @ pagesize+1exec sp_cursorfetch @ p1cale 16, "pagemai" pagesize exec sp_cursorclose @ p1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.