查询一定条数的数据代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】查询一定条数的数据
作者:Dezai.CN / 发布于2011/7/7/ 424
<div><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,128)"> Author: <Author,,sufei></span><span style="color: rgb(0,128,128)">
--</span><span style="color: rgb(0,128,128)"> Create date: <20090808></span><span style="color: rgb(0,128,128)">
--</span><span style="color: rgb(0,128,128)"> Description: <查询一定条数的数据></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)">ALTER</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)">S_selectNumber</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,0)">@tableNmae</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">50</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)">@number</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(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)">@Where</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">200</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)">@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">500</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(128,128,128)">=</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(128,128,128)">+</span><span style="color: rgb(0,128,0)">@number</span><span style="color: rgb(128,128,128)">+</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(128,128,128)">+</span><span style="color: rgb(0,128,0)">@tableNmae</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)">where </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,128,0)">@Where</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)">@strSql</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>
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)