【文章內(nèi)容簡介】
ct max set @strOrder = order by [ + @fldName +] asc end set @strSQL = select top + str(@PageSize) + * from [ + @tblName + ] where [ + @fldName + ] + @strTmp + ([ + @fldName + ]) from (select top + str((@PageIndex1)*@PageSize) + [ + @fldName + ] from [ + @tblName + ] + @strOrder + ) as tblTmp) + @strOrder if @strWhere != set @strSQL = select top + str(@PageSize) +