SQL2000 2005 破解函数,过程,触发器,视图代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 SQL2000 2005 破解函数,过程,触发器,视图
作者:Dezai.CN / 发布于2011/3/15/ 877
<div><span style="color: rgb(0,0,0)">.使用 DAC 与服务器连接 
在 SQL Server Management Studio 中，不打开其他 DAC，单击工具栏上的&ldquo;数据库引擎查询&rdquo;。 
在&ldquo;连接到数据库引擎&rdquo;对话框的&ldquo;服务器名称&rdquo;框中，键入 ADMIN:，并在其后继续键入服务器实例的名称。例如，若要连接到名为 ACCT\PAYABLE 的服务器实例，请键入 ADMIN:ACCT\PAYABLE。
完成&ldquo;身份验证&rdquo;部分（提供 sysadmin 组成员的凭据），然后单击&ldquo;连接&rdquo;。将建立连接。

</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(0,0,0)">.</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">DAC设置可以连接，</span><span style="color: rgb(0,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)">-</span><span style="color: rgb(0,0,0)"> 指明仅允许本地连接使用 DAC 
</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)"> 指明允许远程连接使用 DAC
sp_configure </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">remote admin connections</span><span style="color: rgb(255,0,0)">'</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)">GO</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">RECONFIGURE</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)"> 

在STUDIO DAC模试下执行或在sqlcmd </span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,0,0)">A </span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,0,0)">o c:\</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">.txt模式下执行，输出文件 

</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)">@return_value</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,0,255)">EXEC</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@return_value</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)">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__windbi$decryptb</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> testencry,
</span><span style="color: rgb(0,128,0)">@revfl</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Return Value</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)">@return_value</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,0,255)">view</span><span style="color: rgb(0,0,0)"> plaincopy </span><span style="color: rgb(0,0,255)">to</span><span style="color: rgb(0,0,0)"> clipboardprint?

</span><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)">sp_undecrypt</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)"> 
(</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)"> sysname </span><span style="color: rgb(128,128,128)">=</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,128,0)">@revfl</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,0,255)">AS</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,128,128)">/**//*</span><span style="color: rgb(0,128,128)"> 
王成辉翻译整理，转贴请注明出自微软BI开拓者www.windbi.com 
调用形式为： 
exec dbo.sp__windbi$decrypt @procedure,0 
如果第二个参数使用1的话，会给出该存储过程的一些提示。 
--版本4.0 修正存储过程过长解密出来是空白的问题 
</span><span style="color: rgb(0,128,128)">*/</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)"> NOCOUNT </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)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@revfl</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)">PRINT</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)">PRINT</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)">PRINT</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)">PRINT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> 为了运行这个存储过程，将参数@refl的值更改为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)">RETURN</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)">END</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)">@intProcSpace</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">bigint</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@t</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">bigint</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@maxColID</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">smallint</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(0,128,0)">@procNameLength</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,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@maxColID</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)">max</span><span style="color: rgb(0,0,0)">(subobjid) </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> 
sys.sysobjvalues </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> objid </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">object_id</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">select @maxColID as 'Rows in sys.sysobjvalues' </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@procNameLength</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)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@procedure</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">29</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)">@real_01</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(255,0,255)">max</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)">@fake_01</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(255,0,255)">max</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)">@fake_encrypt_01</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(255,0,255)">max</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)">@real_decrypt_01</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">),</span><span style="color: rgb(0,128,0)">@real_decrypt_01a</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(255,0,255)">max</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)">@objtype</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">2</span><span style="color: rgb(0,0,0)">),</span><span style="color: rgb(0,128,0)">@ParentName</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@real_decrypt_01a</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)">提取对象的类型如是存储过程还是函数，如果是触发器，还要得到其父对象的名称 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">type,</span><span style="color: rgb(0,128,0)">@parentname</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,255)">object_name</span><span style="color: rgb(0,0,0)">(parent_object_id) 
</span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> sys.objects </span><span style="color: rgb(0,0,255)">where</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">object_id</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,255)">object_id</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)"> 从sys.sysobjvalues里提出加密的imageval记录 </span><span style="color: rgb(0,128,128)">
</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)">@real_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">top</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)"> imageval </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sys.sysobjvalues </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> objid </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(255,0,255)">object_id</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> valclass </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)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> subobjid) 

</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)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">table</span><span style="color: rgb(0,0,0)"> #output ( </span><span style="color: rgb(255,0,0)">[</span><span style="color: rgb(255,0,0)">ident</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)">int</span><span style="color: rgb(255,0,0)">]</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">IDENTITY</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,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">NOT</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(255,0,0)">[</span><span style="color: rgb(255,0,0)">real_decrypt</span><span style="color: rgb(255,0,0)">]</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(255,0,255)">MAX</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)">BEGIN</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TRAN</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">P</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ALTER PROCEDURE </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)">@procedure</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)"> WITH ENCRYPTION AS select 1 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">FN</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ALTER FUNCTION </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)">@procedure</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)">() RETURNS INT WITH ENCRYPTION AS BEGIN RETURN 1 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/ END</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">V</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ALTER view </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)">@procedure</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)"> WITH ENCRYPTION AS select 1 as col 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">TR</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ALTER trigger </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)">@procedure</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)"> ON </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,128,0)">@parentname</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">WITH ENCRYPTION AFTER INSERT AS RAISERROR (</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(255,0,0)">N</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(255,0,0)">,16,10) 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">EXECUTE</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,128,0)">@fake_01</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">从sys.sysobjvalues里提出加密的假的 </span><span style="color: rgb(0,128,128)">
</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)">@fake_encrypt_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">top</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)"> imageval </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> sys.sysobjvalues </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> objid </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(255,0,255)">object_id</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@procedure</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> valclass </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)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> subobjid ) 
</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)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">P</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Create PROCEDURE </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)">@procedure</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)"> WITH ENCRYPTION AS select 1 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">FN</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">CREATE FUNCTION </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)">@procedure</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)">() RETURNS INT WITH ENCRYPTION AS BEGIN RETURN 1 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/ END</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">V</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Create view </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)">@procedure</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)"> WITH ENCRYPTION AS select 1 as col 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</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)">if</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@objtype</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">TR</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)">@fake_01</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Create trigger </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)">@procedure</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)"> ON </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,128,0)">@parentname</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">WITH ENCRYPTION AFTER INSERT AS RAISERROR (</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(255,0,0)">N</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(255,0,0)">,16,10) 
/**//*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(255,0,255)">REPLICATE</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(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,255)">as</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), </span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">@procNameLength</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)">*/</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)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@intProcSpace</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(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)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@real_decrypt_01</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)">replicate</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(255,0,0)">'</span><span style="color: rgb(255,0,0)">A</span><span style="color: rgb(255,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)">nvarchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">max</span><span style="color: rgb(0,0,0)">)), (</span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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)">每次一个字节 </span><span style="color: rgb(0,128,128)">
</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)">@intProcSpace</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(0,128,128)">--</span><span style="color: rgb(0,128,128)">如有必要，遍历每个@real_xx变量并解密 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">WHILE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@intProcSpace</span><span style="color: rgb(128,128,128)"><=</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">datalength</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">/</span><span style="color: rgb(128,0,0); font-weight: bold">2</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,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)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@real_decrypt_01</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)">stuff</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_decrypt_01</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@intProcSpace</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)">NCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">UNICODE</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">substring</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@real_01</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@intProcSpace</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(255,0,255)">UNICODE</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">substring</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@fake_01</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@intProcSpace</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(255,0,255)">UNICODE</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">substring</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@fake_encrypt_01</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@intProcSpace</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)">SET</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@intProcSpace</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,128,0)">@intProcSpace</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(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)">通过sp_helptext逻辑向表#output里插入变量 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> #output (real_decrypt) </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@real_decrypt_01</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">select real_decrypt AS '#output chek' from #output --测试 </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)">开始从sp_helptext提取 </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)">@dbname</span><span style="color: rgb(0,0,0)"> sysname 
,</span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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,0)">@BasePos</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,0)">@CurrentPos</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,0)">@TextLength</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,0)">@LineId</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,0)">@AddOnLen</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,0)">@LFCR</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,0,0)">,</span><span style="color: rgb(0,128,0)">@DefinedLength</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,0)">@SyscomText</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(255,0,255)">max</span><span style="color: rgb(0,0,0)">) 
,</span><span style="color: rgb(0,128,0)">@Line</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">255</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@DefinedLength</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">255</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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)">跟踪行结束的空格。注意Len函数忽略了多余的空格 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">CREATE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TABLE</span><span style="color: rgb(0,0,0)"> #CommentText 
(LineId </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)"> 
,</span><span style="color: rgb(0,0,255)">Text</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">255</span><span style="color: rgb(0,0,0)">) collate database_default) 
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">使用#output代替sys.sysobjvalues </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)"> ms_crs_syscom </span><span style="color: rgb(0,0,255)">CURSOR</span><span style="color: rgb(0,0,0)"> LOCAL 
</span><span style="color: rgb(0,0,255)">FOR</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> real_decrypt </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> #output 
</span><span style="color: rgb(0,0,255)">ORDER</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">BY</span><span style="color: rgb(0,0,0)"> ident 
</span><span style="color: rgb(0,0,255)">FOR</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">READ</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">ONLY</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@LFCR</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">2</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@LineId</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)">OPEN</span><span style="color: rgb(0,0,0)"> ms_crs_syscom 
</span><span style="color: rgb(0,0,255)">FETCH</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">NEXT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> ms_crs_syscom </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">WHILE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0); font-weight: bold">@@fetch_status</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BasePos</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@CurrentPos</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@TextLength</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)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">WHILE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@CurrentPos</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,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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@CurrentPos</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)">CHARINDEX</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,0,255)">char</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">13</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,255)">char</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,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, 
</span><span style="color: rgb(0,128,0)">@BasePos</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)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@CurrentPos</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,128,128)">--</span><span style="color: rgb(0,128,128)">如果@Lines的长度的新值比设置的大就插入@Lines目前的内容并继续 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">While</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</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)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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)">@CurrentPos</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,128,0)">@BasePos</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)">@LFCR</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)">@DefinedLength</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@AddOnLen</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)">@DefinedLength</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</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)">+</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">INSERT</span><span style="color: rgb(0,0,0)"> #CommentText </span><span style="color: rgb(0,0,255)">VALUES</span><span style="color: rgb(0,0,0)"> 
( </span><span style="color: rgb(0,128,0)">@LineId</span><span style="color: rgb(0,0,0)">, 
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)">, N</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">SUBSTRING</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, 
</span><span style="color: rgb(0,128,0)">@BasePos</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@AddOnLen</span><span style="color: rgb(0,0,0)">), N</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">)) 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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,0,255)">NULL</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@LineId</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)">@LineId</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,0)">@BasePos</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)">@BasePos</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)">@AddOnLen</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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)">END</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)">, N</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">SUBSTRING</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@BasePos</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@CurrentPos</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,128,0)">@BasePos</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)">@LFCR</span><span style="color: rgb(0,0,0)">), N</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BasePos</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)">@CurrentPos</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">INSERT</span><span style="color: rgb(0,0,0)"> #CommentText </span><span style="color: rgb(0,0,255)">VALUES</span><span style="color: rgb(0,0,0)">( </span><span style="color: rgb(0,128,0)">@LineId</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)"> ) 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@LineId</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)">@LineId</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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,0,255)">NULL</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,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)">BEGIN</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)">@BasePos</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)">@TextLength</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,128,128)">--</span><span style="color: rgb(0,128,128)">如果@Lines长度的新值大于定义的长度 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">While</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</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)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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)">@TextLength</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,128,0)">@BasePos</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,0,0)"> </span><span style="color: rgb(0,128,0)">@DefinedLength</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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@AddOnLen</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)">@DefinedLength</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</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)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">INSERT</span><span style="color: rgb(0,0,0)"> #CommentText </span><span style="color: rgb(0,0,255)">VALUES</span><span style="color: rgb(0,0,0)"> 
( </span><span style="color: rgb(0,128,0)">@LineId</span><span style="color: rgb(0,0,0)">, 
</span><span style="color: rgb(255,0,255)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)">, N</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">SUBSTRING</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, 
</span><span style="color: rgb(0,128,0)">@BasePos</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@AddOnLen</span><span style="color: rgb(0,0,0)">), N</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">)) 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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,0,255)">NULL</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@LineId</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)">@LineId</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,0)">@BasePos</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)">@BasePos</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)">@AddOnLen</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@BlankSpaceAdded</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)">END</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)">, N</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)">isnull</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">SUBSTRING</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@BasePos</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@TextLength</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,128,0)">@BasePos</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)"> ), N</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(255,0,255)">LEN</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@Line</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)">@DefinedLength</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">charindex</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,0)">@SyscomText</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@TextLength</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,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)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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)">@Line</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,0)">@BlankSpaceAdded</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)">END</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)">END</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)">FETCH</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">NEXT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> ms_crs_syscom </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@SyscomText</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)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@Line</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(128,128,128)">NOT</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)">INSERT</span><span style="color: rgb(0,0,0)"> #CommentText </span><span style="color: rgb(0,0,255)">VALUES</span><span style="color: rgb(0,0,0)">( </span><span style="color: rgb(0,128,0)">@LineId</span><span style="color: rgb(0,0,0)">, </span><span style="color: rgb(0,128,0)">@Line</span><span style="color: rgb(0,0,0)"> ) 
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Text</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> #CommentText </span><span style="color: rgb(0,0,255)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> LineId 
</span><span style="color: rgb(0,0,255)">CLOSE</span><span style="color: rgb(0,0,0)"> ms_crs_syscom 
</span><span style="color: rgb(0,0,255)">DEALLOCATE</span><span style="color: rgb(0,0,0)"> ms_crs_syscom 
</span><span style="color: rgb(0,0,255)">DROP</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TABLE</span><span style="color: rgb(0,0,0)"> #CommentText 
</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)">结束从sp_helptext提取 </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)">删除用短横线创建的存储过程并重建原始的存储过程 </span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">ROLLBACK</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TRAN</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">DROP</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TABLE</span><span style="color: rgb(0,0,0)"> #output 
</span></div>
试试其它关键字
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)