mssql海量高效分页存储过程代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 mssql海量高效分页存储过程
作者:CSDN / 发布于2012/1/11/ 895
<div><span style="color: rgb(0,0,255)">CREATE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">PROCEDURE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">dbo</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">.</span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">PROC_GetListRecordByPage</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">255</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 表名</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">255</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 主键字段名</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">INT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">10</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 页尺寸</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">INT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 页码</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@IsReCount</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">INT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 0 返回记录总数; 1只返回数据; 2 都返回</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@OrderType</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">BIT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 设置排序类型, 非 0 值则降序</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">3000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 查询条件 (注意: 不要加 where)</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">1000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">需要返回的列</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">BEGIN</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">DECLARE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tempSql</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">6000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 临时语句</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">DECLARE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSqlAll</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">6000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 主语句</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">DECLARE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSqlCnt</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">400</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 数据数量</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">DECLARe</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderTypeStr</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">NVARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">20</span><span style="color: rgb(0,0,0)">)

</span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderType</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">or</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderType</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">is</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">null</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderTypeStr</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">DESC</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderTypeStr</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ASC</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">


</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tempSql</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">SELECT ROW_NUMBER() OVER (ORDER BY [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderTypeStr</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">) AS rowId,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> FROM [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tempSql</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tempSql</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> WHERE </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSqlAll</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">SELECT * FROM (</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tempSql</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">) t WHERE rowId BETWEEN </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">CAST</span><span style="color: rgb(0,0,0)">(((</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> AND </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">CAST</span><span style="color: rgb(0,0,0)">((</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)"> ) </span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">);
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">PRINT @strSqlAll</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">EXEC</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,128,0)">@strSqlAll</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@IsReCount</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSqlCnt</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">SELECT COUNT(1) AS Total FROM [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] WHERE </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSqlCnt</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">SELECT COUNT(1) AS Total FROM [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">EXEC</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,128,0)">@strSqlCnt</span><span style="color: rgb(0,0,0)">)

</span><span style="color: rgb(0,0,255)">END</span><span style="color: rgb(0,0,0)"> 
</span></div>
<div></div>
<div></div>
<div><span style="color: rgb(0,0,0)">或者</span></div>
<div></div>
<div><span style="color: rgb(0,0,0)"><span style="color: rgb(0,0,255)">CREATE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">PROCEDURE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">dbo</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">.</span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">PROC_GetListByPage_Sql2000</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">255</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 表名</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">255</span><span style="color: rgb(0,0,0)">), </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 排序字段名 随机为newid()</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">10</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 页尺寸</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 页码</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@IsReCount</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 0 返回记录总数; 1只返回数据; 2 都返回</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@OrderType</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">bit</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 设置排序类型, 非 0 值则降序</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">3000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 查询条件 (注意: 不要加 where)</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">1000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">需要返回的列</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">AS</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">6000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 主语句</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">6000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 主语句</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">2000</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 临时变量</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">400</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 排序类型</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@OrderType</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">0</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"><(select min</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> order by </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> desc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">>(select max</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> order by </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> asc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">select top </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">str</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] where [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">([</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]) from (select top </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">str</span><span style="color: rgb(0,0,0)">((</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">) as tblTmp)</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">select top </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">str</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] where [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">([</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]) from (select top </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">str</span><span style="color: rgb(0,0,0)">((</span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@fldName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">] where </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">) as tblTmp) and </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@PageIndex</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> where </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">select top </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">str</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@PageSize</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@returnFld</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strTmp</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strOrder</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">print @strSQL</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">exec</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,128,0)">@strSQL</span><span style="color: rgb(0,0,0)">)

</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@IsReCount</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">!=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">select count(*) as Total from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> where </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strWhere</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">else</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strSQL1</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">select count(*) as Total from [</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@tblName</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">exec</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,128,0)">@strSQL1</span><span style="color: rgb(0,0,0)">) 

</span></span></div>
试试其它关键字
　高效分页存储过程　
同语言下
可能有用的
CSDN贡献的其它代码(27)