根据条件查询的方法代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】根据条件查询的方法
作者:Dezai.CN / 发布于2011/7/7/ 530
<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_selectOne</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)">@Colum</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)">要查询的列名用&ldquo;，&rdquo;分开</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">200</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 </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,128,0)">@Colum</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)">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(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)