领测软件测试网
:gkpc]h软件测试技术门户({uE+z9o else
软件测试技术门户
dL!tO5vf begin
h3[*l)c)C'z set @strTmp = ">(select max"
软件测试技术门户.Tu/}/`&cSIE+N set @strOrder = " order by [" + @fldName +"] asc"
软件测试技术门户-U:k(D%^5y0?W end
$H&MIk3gW*j;F&f if @PageIndex = 1
软件测试技术门户3X5MauEzLF begin
,I%x6N!Zcg'^:I if @strWhere != ’’
软件测试技术门户Tn?:N5^[VI3v set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ " from [" + @tblName + "] where " + @strWhere + " " + @strOrder
软件测试技术门户}kGm N)u else
/aM^2cPOiN set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ " from ["+ @tblName + "] "+ @strOrder
Q$a`2cs)B --如果是第一页就执行以上代码,这样会加快执行速度
!Q't
sI${&D~,\ end
软件测试技术门户*qb ]F,L else
r6|Smx*C#v2X!\/Q*y_ begin
{