摘要： if object_id('tempdb.dbo.##P_Sys_getUserShellNew') is not null drop table ##P_Sys_getUserShellNew ; declare @iStart int declare @iEnd int SET @iStart = (@PageIndex-1)*@PageSize+1 SET @iEnd = (@PageIndex-1)*@PageSize+@PageSize ;with #temp1 as( sel... 阅读全文