查询所有的名称通用过程代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】查询所有的名称通用过程

作者:Dezai.CN / 发布于2011/7/7/ 555

<div><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> ANSI_NULLS </span><span style="color: rgb(0,0,255)">ON</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)"> QUOTED_IDENTIFIER </span><span style="color: rgb(0,0,255)">ON</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">go</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,128)"> Author: <Author sufei></span><span style="color: rgb(0,128,128)">
--</span><span style="color: rgb(0,128,128)"> Create date: <Create 2090806></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)">SP_select</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,0)">@tableName</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">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,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)">@str</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)">@str</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,0,0)"> </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(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,128,0)">@tableName</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)">@str</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)