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

代码语言
代码分类
【MSSQL】查询所有的名称通用过程
作者:Dezai.CN / 发布于2011/7/7/ 572
<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)