<?xml version="1.0" encoding="UTF-8"?>
  <feed xmlns="http://www.w3.org/2005/Atom">
  <title type="html"><![CDATA[飞桥工作室FeiQiao Studio]]></title>
  <subtitle type="html"><![CDATA[专注与WEB技术研究与开发]]></subtitle>
  <id>http://www.feiqiao.net/blog/</id>
  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/" /> 
  <link rel="self" type="application/atom+xml" href="http://www.feiqiao.net/blog/atom.asp" /> 
  <generator uri="http://www.pjhome.net/" version="2.8">PJBlog3</generator> 
  <updated>2008-11-06T09:34:38+08:00</updated>

  <entry>
	  <title type="html"><![CDATA[电脑屏幕调节 保护眼睛的好方法 ]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=9" label="Computer" /> 
	  <updated>2008-11-06T09:34:38+08:00</updated>
	  <published>2008-11-06T09:34:38+08:00</published>
		  <summary type="html"><![CDATA[<p>电脑屏幕调节 保护眼睛的好方法 <br />
&nbsp;<br />
&nbsp;桌面-&gt;右键-&gt;属性-&gt;外观-&gt;高级－&gt;项目选择（窗口）、颜色1（L）选择（其它）将色调改为：85。饱和度：123。亮度：205－&gt;添加到自定义颜色－&gt;在自定义颜色选定点确定－&gt;确定这样所有的文档都不再是刺眼的白底黑字，而是非常柔和的豆沙绿色，这个色调是眼科专家配置的，长时间使用会很有效的缓解眼睛疲劳保护眼睛&nbsp; 别忘了分享给你们的好朋友哦<br />
&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/86.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=86</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[MSDN原版VS2005,SQL2005迅雷高速下载]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=16" label="ASP.NET" /> 
	  <updated>2008-11-02T11:10:21+08:00</updated>
	  <published>2008-11-02T11:10:21+08:00</published>
		  <summary type="html"><![CDATA[<p>MSDN原版VS2005,SQL2005,Windows XP/2003, Office 2003(ftp下载)~~~~~~迅雷下载!~~~~~500kb/s<br />
Microsoft Visual Studio 2005专业版简体中文版DVD镜像<br />
Microsoft Visual Studio 2005 Professional Edition Chinese (Simplified) DVD Image <br />
MD5:a276ac538303af951d2c3b60777cc22a <br />
<a href="ftp://vipdownload:vipdownload@210.51.22.77:8021/cs_vs_2005_pro_dvd.iso" target="_blank">ftp://vipdownload:vipdownload@21 ... vs_2005_pro_dvd.iso</a> <br />
Microsoft&nbsp; SQL Server 2005 开发版简体中文版DVD镜像<br />
Microsoft SQL Server 2005 Develop Edition Chinese (Simplified) DVD Image <br />
MD5:c552587552d7a31a8c708a6f5d563b52 <br />
<a href="ftp://vipdownload:vipdownload@210.51.22.77:8021/cs_sql_2005_dev_all_dvd.iso" target="_blank">ftp://vipdownload:vipdownload@21 ... 005_dev_all_dvd.iso</a> <br />
<br />
Microsoft Windows Server 2003 Enterprise Edition with SP1 Chinese (Simplified) CD Image <br />
MD5:554650288b755a84285eb3b6d6cd159c <br />
<a href="ftp://vipdownload:vipdownload@210.51.22.77:8021/Microsoft.Windows.Server.2003.Enterprise.CHS.with.SP1.MSDN_KXWPJ-6VWT6-YTY44-3WCFR-M3KVM.iso" target="_blank">ftp://vipdownload:vipdownload@21 ... Y44-3WCFR-M3KVM.iso</a> <br />
<br />
Microsoft Windows XP Professional Edition with SP2 Chinese (Simplified) CD Image <br />
MD5:2637e695f43329fc9d66feceee44bf1f <br />
<a href="ftp://vipdownload:vipdownload@210.51.22.77:8021/Microsoft.Windows.XP.Professional.CHS.with.SP2.MSDN_DG8FV-B9TKY-FRT9J-6CRCC-XPQ4G.iso" target="_blank">ftp://vipdownload:vipdownload@21 ... T9J-6CRCC-XPQ4G.iso</a> <br />
<br />
Microsoft Office 2003 Professional Edition Chinese (Simplified) CD Image <br />
MD5:043b323428af8e00b8cdba07b7b0b1a7 <br />
<a href="ftp://vipdownload:vipdownload@210.51.22.77:8021/sc_office_2003_pro.iso" target="_blank">ftp://vipdownload:vipdownload@21 ... office_2003_pro.iso</a></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/85.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=85</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[MMC不能打开文件MSC文件]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=9" label="Computer" /> 
	  <updated>2008-10-15T11:12:16+08:00</updated>
	  <published>2008-10-15T11:12:16+08:00</published>
		  <summary type="html"><![CDATA[<p>&nbsp; 今天在打开IIS管理，结果出现：MMC不能打开文件MSC文件。当时傻了，晕，电脑怎么了，怎么出现这些！中毒了？晕了？</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; 我在打开设备管理器时电脑也提示: MMC不能打开c:\WINDOWS\system32\devmgmt.msc 这可能是由于文件不存在,不是一个MMC控制台,或者用后来版本的MMC创建。也可能是由于您没有访问此文件的足够权限。倒！！！找了N篇文章，终于找到了一个命令：</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; 在我的电脑中运行：regsvr32 C:\Windows\system32\msxml3.dll</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; 马上出现，修复成功，白担心了一场，以为自己的电脑怎么了</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/84.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=84</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[dl dt dd标签用法]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=6" label="Javascript/CSS" /> 
	  <updated>2008-09-18T11:00:40+08:00</updated>
	  <published>2008-09-18T11:00:40+08:00</published>
		  <summary type="html"><![CDATA[<p>一般我们在做列表的时候通常只会用到ul和li标签,至于DL一般都很少用到，它也属于列表类的标签，下面说一下大概的用法：<br />
<br />
&lt;dl&gt;标记定义了一个定义列表，定义列表中的条目是通过使用&lt;dt&gt;标记(&ldquo;definition title&rdquo;，定义标题)和&lt;dd&gt;标记(&ldquo;definition description&rdquo;，定义描述)创建的。&lt;dt&gt;给出了术语名，&lt;dd&gt;标记给出了术语的定义。<br />
<br />
也就是说&lt;dt&gt;用来创建列表中的上层项目，&lt;dd&gt;用来创建列表中最下层项目，&lt;dt&gt;和&lt;dd&gt;都必须放在&lt;dl&gt;&lt; /dl&gt;标志对之间。</p>
<p>&nbsp;</p>
<div class="codeText">
<div class="codeHead">XML/HTML代码</div>
<ol class="dp-xml" start="1">
    <li class="alt"><span><span>&lt;!DOCTYPE&nbsp;html&nbsp;PUBLIC&nbsp;&quot;-//W3C//DTD&nbsp;XHTML&nbsp;1.0&nbsp;Transitional//EN&quot;&nbsp;&quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">html</span><span>&nbsp;</span><span class="attribute">xmlns</span><span>=</span><span class="attribute-value">&quot;http://www.w3.org/1999/xhtml&quot;</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">head</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">meta</span><span>&nbsp;</span><span class="attribute">http-equiv</span><span>=</span><span class="attribute-value">&quot;Content-Type&quot;</span><span>&nbsp;</span><span class="attribute">content</span><span>=</span><span class="attribute-value">&quot;text/html;&nbsp;charset=gb2312&quot;</span><span>&nbsp;</span><span class="tag">/&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">title</span><span class="tag">&gt;</span><span>无标题文档</span><span class="tag">&lt;/</span><span class="tag-name">title</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">style</span><span>&nbsp;</span><span class="attribute">type</span><span>=</span><span class="attribute-value">&quot;text/css&quot;</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&lt;!--&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;</span></li>
    <li class="alt"><span>*{&nbsp;margin:0;&nbsp;padding:0;}&nbsp;&nbsp;</span></li>
    <li><span>body{&nbsp;font-size:14px;}&nbsp;&nbsp;</span></li>
    <li class="alt"><span>dl{clear:both;&nbsp;float:left;&nbsp;border:#0099FF&nbsp;1px&nbsp;solid;&nbsp;width:200px}&nbsp;&nbsp;</span></li>
    <li><span>dt{float:left;&nbsp;background:&nbsp;#72F58F;width:200px}&nbsp;&nbsp;</span></li>
    <li class="alt"><span>dd{&nbsp;float:left;width:200px}&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;</span></li>
    <li><span>--<span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;/</span><span class="tag-name">style</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;/</span><span class="tag-name">head</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;</span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">body</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">dl</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">dt</span><span class="tag">&gt;</span><span>飞桥客户案例</span><span class="tag">&lt;/</span><span class="tag-name">dt</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>隆福珠宝</span><span class="tag">&lt;/</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>合家欢装饰</span><span class="tag">&lt;/</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>案例3</span><span class="tag">&lt;/</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>案例4</span><span class="tag">&lt;/</span><span class="tag-name">dd</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;</span></li>
    <li><span><span class="tag">&lt;/</span><span class="tag-name">dl</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span><span class="tag">&lt;/</span><span class="tag-name">body</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span><span class="tag">&lt;/</span><span class="tag-name">html</span><span class="tag">&gt;</span><span>&nbsp;&nbsp;</span></span></li>
</ol>
</div>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/83.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=83</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[php基本符号]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=17" label="PHP" /> 
	  <updated>2008-09-10T10:51:53+08:00</updated>
	  <published>2008-09-10T10:51:53+08:00</published>
		  <summary type="html"><![CDATA[<p>注解符号:&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;单行注解&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/&nbsp;&nbsp;&nbsp;多行注解&nbsp; <br />
<br />
引号的使用&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&rsquo;&nbsp;&nbsp;&rsquo;&nbsp;单引号,没有任何意义,不经任何处理直接拿过来;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&nbsp;&quot;双引号,php动态处理然后输出,一般用于变数.&nbsp; <br />
<br />
变数形态:&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;一种是True&nbsp;即&nbsp;真的;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;另一种是False&nbsp;即假的&nbsp; <br />
<br />
常见变数形态:&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;字串(数字\汉字\等等)&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;整数(1、2、3、4、5、0、-1、-2、等等)&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;double&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;浮点数（小数点）&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;array&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;阵列&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;object&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;物件&nbsp; <br />
<br />
常用符号&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;双引号&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\\&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;反斜线&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>&nbsp;&nbsp;\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;换行&nbsp;</strong> <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;送出&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;跳位(TAB)&nbsp; <br />
<br />
运算符号&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;加法运算&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;减法运算&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;乘法运算&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;除法运算&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;取余数&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;++&nbsp;&nbsp;&nbsp;&nbsp;累加&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;累减1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把字串相加&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
设定运算&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把右边的值代入左边(一定要会)&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把右边的值加到左边&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把右边的值减到左边&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把左边的值乘以右边&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把左边的值除以右边&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;把右边的字串加到左边&nbsp; <br />
<br />
位员运算&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;且&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;或&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;互斥(xor)&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;&lt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;向左移位&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;向右移位&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;~&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;取1的补数&nbsp; <br />
<br />
逻辑运算&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;小于&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;大于&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;=&nbsp;&nbsp;&nbsp;&nbsp;小于等于&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;大于等于&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;!=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;不等于&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;而且&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;或者&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;不&nbsp; <br />
<br />
其他运算符号&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;变数符号&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;变数的指标(加在变数前)&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: rgb(255, 0, 0);"><strong>@&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;不显示错误信息(加在函数前)</strong></span>&nbsp; <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: rgb(128, 0, 0);">&nbsp;-<strong>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;物件的方法或者属性</strong>&nbsp; </span><br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: rgb(255, 0, 0);">=&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;阵列的元素值&nbsp; </span><br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: rgb(255, 0, 0);">&nbsp;?&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;三元运算子&nbsp;&nbsp;&nbsp;&nbsp;</span>&nbsp;</p>
<p><strong><span style="color: rgb(0, 51, 0);"><font class="f14" id="zoom">其中比较特殊的是三元运算子&nbsp;?&nbsp;&nbsp;&nbsp;:，以下例来解释 <br />
<br />
(expr1)&nbsp;?&nbsp;(expr2)&nbsp;:&nbsp;(expr3); <br />
<br />
若&nbsp;expr1&nbsp;的运算结果为&nbsp;true，则执行&nbsp;expr2；否则执行&nbsp;expr3。实际上它有点类以&nbsp;if...else&nbsp;回圈，但可以让程式较精简有效率。&nbsp;</font></span></strong><span style="color: rgb(0, 51, 0);"><font class="f14" id="zoom"> </font></span></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/82.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=82</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[SQLSERVER2000存储过程解密函数]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=4" label="ASP" /> 
	  <updated>2008-08-19T17:18:07+08:00</updated>
	  <published>2008-08-19T17:18:07+08:00</published>
		  <summary type="html"><![CDATA[<div class="codeText">
<div class="codeHead">SQL代码</div>
<ol class="dp-sql" start="1">
    <li class="alt"><span><span>/*</span><span class="comment">--破解,过程,触发器,视图.仅限于SQLSERVER2000&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="comment">--作者:J9988--&nbsp;&nbsp;&nbsp;All&nbsp;&nbsp;&nbsp;rights&nbsp;&nbsp;&nbsp;reserved*/&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;/*<span class="comment">--调用示例&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="comment">--解密指定存储过程&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">exec</span><span>&nbsp;&nbsp;&nbsp;sp_decrypt&nbsp;&nbsp;&nbsp;</span><span class="string">'AppSP_test'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="comment">--对所有的存储过程解密&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;</span><span class="keyword">cursor</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">for</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">name</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;sysobjects&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;xtype=</span><span class="string">'P'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;status&gt;0&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">name</span><span>&lt;&gt;</span><span class="string">'sp_decrypt'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@</span><span class="keyword">name</span><span>&nbsp;&nbsp;&nbsp;sysname&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">open</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">fetch</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">next</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;</span><span class="keyword">into</span><span>&nbsp;&nbsp;&nbsp;@</span><span class="keyword">name</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;while&nbsp;&nbsp;&nbsp;@@fetch_status=0&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;print&nbsp;&nbsp;&nbsp;<span class="string">'-------存储过程&nbsp;&nbsp;&nbsp;['</span><span>+@</span><span class="keyword">name</span><span>+</span><span class="string">']&nbsp;&nbsp;&nbsp;-----------'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">exec</span><span>&nbsp;&nbsp;&nbsp;sp_decrypt&nbsp;&nbsp;&nbsp;@</span><span class="keyword">name</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">fetch</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">next</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;</span><span class="keyword">into</span><span>&nbsp;&nbsp;&nbsp;@</span><span class="keyword">name</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">close</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">deallocate</span><span>&nbsp;&nbsp;&nbsp;tb&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="comment">--*/&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;exists&nbsp;&nbsp;&nbsp;(<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;*&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;dbo.sysobjects&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;object_id(N</span><span class="string">'[dbo].[SP_DECRYPT]'</span><span>)&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;OBJECTPROPERTY(id,&nbsp;&nbsp;&nbsp;N</span><span class="string">'IsProcedure'</span><span>)&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;1)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">drop</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">procedure</span><span>&nbsp;&nbsp;&nbsp;[dbo].[SP_DECRYPT]&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;GO&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">Create</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">PROCEDURE</span><span>&nbsp;&nbsp;&nbsp;sp_decrypt(@objectName&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(50))&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">AS</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;nocount&nbsp;&nbsp;&nbsp;</span><span class="keyword">on</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="comment">--破解字节不受限制，适用于SQLSERVER2000存储过程，函数，视图，触发器&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="comment">--修正上一版视图触发器不能正确解密错误&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="comment">--发现有错，请E_MAIL：CSDNj9988@tom.com&nbsp;&nbsp;</span><span>&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;tran&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@objectname1&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(100),@orgvarbin&nbsp;&nbsp;&nbsp;varbinary(8000)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@sql1&nbsp;&nbsp;&nbsp;nvarchar(4000),@sql2&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(8000),@sql3&nbsp;&nbsp;&nbsp;nvarchar(4000),@sql4&nbsp;&nbsp;&nbsp;nvarchar(4000)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">DECLARE</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText1&nbsp;&nbsp;&nbsp;nvarchar(4000),&nbsp;&nbsp;&nbsp;@OrigSpText2&nbsp;&nbsp;&nbsp;nvarchar(4000)&nbsp;&nbsp;&nbsp;,&nbsp;&nbsp;&nbsp;@OrigSpText3&nbsp;&nbsp;&nbsp;nvarchar(4000),&nbsp;&nbsp;&nbsp;@resultsp&nbsp;&nbsp;&nbsp;nvarchar(4000)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@i&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@status&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@type&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(10),@parentid&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@colid&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@n&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@q&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@j&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@k&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@encrypted&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,@number&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@type=xtype,@parentid=parent_obj&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;sysobjects&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id=object_id(@ObjectName)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">create</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">table</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>(number&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,colid&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,ctext&nbsp;&nbsp;&nbsp;varbinary(8000),encrypted&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>,status&nbsp;&nbsp;&nbsp;</span><span class="keyword">int</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">insert</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">Select</span><span>&nbsp;&nbsp;&nbsp;number,colid,ctext,encrypted,status&nbsp;&nbsp;&nbsp;</span><span class="keyword">FROM</span><span>&nbsp;&nbsp;&nbsp;syscomments&nbsp;&nbsp;&nbsp;</span><span class="keyword">Where</span><span>&nbsp;&nbsp;&nbsp;id&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;object_id(@objectName)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@number=</span><span class="keyword">max</span><span>(number)&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@k=0&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;while&nbsp;&nbsp;&nbsp;@k&lt;=@number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;exists(<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;syscomments&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id=object_id(@objectname)&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;number=@k)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'P'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=(</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;@number&gt;1&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'Alter&nbsp;&nbsp;&nbsp;PROCEDURE&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName&nbsp;&nbsp;&nbsp;+</span><span class="string">';'</span><span>+rtrim(@k)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'Alter&nbsp;&nbsp;&nbsp;PROCEDURE&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;<span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'TR'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">declare</span><span>&nbsp;&nbsp;&nbsp;@parent_obj&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(255),@tr_parent_xtype&nbsp;&nbsp;&nbsp;</span><span class="keyword">varchar</span><span>(10)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@parent_obj=parent_obj&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;sysobjects&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id=object_id(@objectName)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@tr_parent_xtype=xtype&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;sysobjects&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id=@parent_obj&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@tr_parent_xtype=<span class="string">'V'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=</span><span class="string">'Alter&nbsp;&nbsp;&nbsp;TRIGGER&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;ON&nbsp;&nbsp;&nbsp;'</span><span>+OBJECT_NAME(@parentid)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;INSTERD&nbsp;&nbsp;&nbsp;OF&nbsp;&nbsp;&nbsp;Insert&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;PRINT&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=</span><span class="string">'Alter&nbsp;&nbsp;&nbsp;TRIGGER&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;ON&nbsp;&nbsp;&nbsp;'</span><span>+OBJECT_NAME(@parentid)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;FOR&nbsp;&nbsp;&nbsp;Insert&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;PRINT&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'FN'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="op">or</span><span>&nbsp;&nbsp;&nbsp;@type=</span><span class="string">'TF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="op">or</span><span>&nbsp;&nbsp;&nbsp;@type=</span><span class="string">'IF'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=(</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;@type&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'TF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Alter&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;@b&nbsp;&nbsp;&nbsp;table(a&nbsp;&nbsp;&nbsp;varchar(10))&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;begin&nbsp;&nbsp;&nbsp;insert&nbsp;&nbsp;&nbsp;@b&nbsp;&nbsp;&nbsp;select&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;end&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'FN'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Alter&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;char(1)&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;begin&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;end'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'IF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Alter&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;table&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;select&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;a'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'V'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=</span><span class="string">'Alter&nbsp;&nbsp;&nbsp;VIEW&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;Select&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;f'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@q=len(@sql1)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql1=@sql1+REPLICATE(</span><span class="string">'-'</span><span>,4000-@q)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@sql2=REPLICATE(</span><span class="string">'-'</span><span>,8000)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql3=</span><span class="string">'exec(@sql1'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@colid=</span><span class="keyword">max</span><span>(colid)&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;number=@k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@n=1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;while&nbsp;&nbsp;&nbsp;@n&lt;=CEILING(1.0*(@colid-1)/2)&nbsp;&nbsp;&nbsp;<span class="op">and</span><span>&nbsp;&nbsp;&nbsp;len(@sQL3)&lt;=3996&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql3=@sql3+</span><span class="string">'+@'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@n=@n+1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@sql3=@sql3+</span><span class="string">')'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">exec</span><span>&nbsp;&nbsp;&nbsp;sp_executesql&nbsp;&nbsp;&nbsp;@sql3,N</span><span class="string">'@sql1&nbsp;&nbsp;&nbsp;nvarchar(4000),@&nbsp;&nbsp;&nbsp;varchar(8000)'</span><span>,@sql1=@sql1,@=@sql2&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@k=@k+1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@k=0&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;while&nbsp;&nbsp;&nbsp;@k&lt;=@number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;exists(<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;syscomments&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;id=object_id(@objectname)&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;number=@k)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@colid=</span><span class="keyword">max</span><span>(colid)&nbsp;&nbsp;&nbsp;</span><span class="keyword">from</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">where</span><span>&nbsp;&nbsp;&nbsp;number=@k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@n=1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;while&nbsp;&nbsp;&nbsp;@n&lt;=@colid&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">select</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText1=ctext,@encrypted=encrypted,@status=status&nbsp;&nbsp;&nbsp;</span><span class="keyword">FROM</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">Where</span><span>&nbsp;&nbsp;&nbsp;colid=@n&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;number=@k&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText3=(</span><span class="keyword">Select</span><span>&nbsp;&nbsp;&nbsp;ctext&nbsp;&nbsp;&nbsp;</span><span class="keyword">FROM</span><span>&nbsp;&nbsp;&nbsp;syscomments&nbsp;&nbsp;&nbsp;</span><span class="keyword">Where</span><span>&nbsp;&nbsp;&nbsp;id=object_id(@objectName)&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;colid=@n&nbsp;&nbsp;&nbsp;</span><span class="op">and</span><span>&nbsp;&nbsp;&nbsp;number=@k)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@n=1&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'P'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=(</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;@number&gt;1&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'Create&nbsp;&nbsp;&nbsp;PROCEDURE&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName&nbsp;&nbsp;&nbsp;+</span><span class="string">';'</span><span>+rtrim(@k)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'Create&nbsp;&nbsp;&nbsp;PROCEDURE&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName&nbsp;&nbsp;&nbsp;+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'FN'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="op">or</span><span>&nbsp;&nbsp;&nbsp;@type=</span><span class="string">'TF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="op">or</span><span>&nbsp;&nbsp;&nbsp;@type=</span><span class="string">'IF'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=(</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;@type&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'TF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Create&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;@b&nbsp;&nbsp;&nbsp;table(a&nbsp;&nbsp;&nbsp;varchar(10))&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;begin&nbsp;&nbsp;&nbsp;insert&nbsp;&nbsp;&nbsp;@b&nbsp;&nbsp;&nbsp;select&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;end&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'FN'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Create&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;char(1)&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;begin&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;end'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;</span><span class="string">'IF'</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="string">'Create&nbsp;&nbsp;&nbsp;FUNCTION&nbsp;&nbsp;&nbsp;'</span><span>+&nbsp;&nbsp;&nbsp;@objectName+</span><span class="string">'(@a&nbsp;&nbsp;&nbsp;char(1))&nbsp;&nbsp;&nbsp;returns&nbsp;&nbsp;&nbsp;table&nbsp;&nbsp;&nbsp;with&nbsp;&nbsp;&nbsp;encryption&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;return&nbsp;&nbsp;&nbsp;select&nbsp;&nbsp;&nbsp;@a&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;a'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'TR'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@tr_parent_xtype=<span class="string">'V'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=</span><span class="string">'Create&nbsp;&nbsp;&nbsp;TRIGGER&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;ON&nbsp;&nbsp;&nbsp;'</span><span>+OBJECT_NAME(@parentid)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;INSTEAD&nbsp;&nbsp;&nbsp;OF&nbsp;&nbsp;&nbsp;Insert&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;PRINT&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=</span><span class="string">'Create&nbsp;&nbsp;&nbsp;TRIGGER&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;ON&nbsp;&nbsp;&nbsp;'</span><span>+OBJECT_NAME(@parentid)+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;FOR&nbsp;&nbsp;&nbsp;Insert&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;PRINT&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;if&nbsp;&nbsp;&nbsp;@type=<span class="string">'V'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=</span><span class="string">'Create&nbsp;&nbsp;&nbsp;VIEW&nbsp;&nbsp;&nbsp;'</span><span>+@objectname+</span><span class="string">'&nbsp;&nbsp;&nbsp;WITH&nbsp;&nbsp;&nbsp;ENCRYPTION&nbsp;&nbsp;&nbsp;AS&nbsp;&nbsp;&nbsp;Select&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;as&nbsp;&nbsp;&nbsp;f'</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@q=4000-len(@OrigSpText2)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=@OrigSpText2+REPLICATE(</span><span class="string">'-'</span><span>,@q)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">begin</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@OrigSpText2=REPLICATE(</span><span class="string">'-'</span><span>,&nbsp;&nbsp;&nbsp;4000)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@i=1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@resultsp&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;replicate(N</span><span class="string">'A'</span><span>,&nbsp;&nbsp;&nbsp;(datalength(@OrigSpText1)&nbsp;&nbsp;&nbsp;/&nbsp;&nbsp;&nbsp;2))&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;WHILE&nbsp;&nbsp;&nbsp;@i&lt;=datalength(@OrigSpText1)/2&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">BEGIN</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@resultsp&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;&nbsp;stuff(@resultsp,&nbsp;&nbsp;&nbsp;@i,&nbsp;&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;</span><span class="keyword">NCHAR</span><span>(UNICODE(</span><span class="func">substring</span><span>(@OrigSpText1,&nbsp;&nbsp;&nbsp;@i,&nbsp;&nbsp;&nbsp;1))&nbsp;&nbsp;&nbsp;^&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;(UNICODE(<span class="func">substring</span><span>(@OrigSpText2,&nbsp;&nbsp;&nbsp;@i,&nbsp;&nbsp;&nbsp;1))&nbsp;&nbsp;&nbsp;^&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;UNICODE(<span class="func">substring</span><span>(@OrigSpText3,&nbsp;&nbsp;&nbsp;@i,&nbsp;&nbsp;&nbsp;1)))))&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">SET</span><span>&nbsp;&nbsp;&nbsp;@i=@i+1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">END</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@orgvarbin=</span><span class="func">cast</span><span>(@OrigSpText1&nbsp;&nbsp;&nbsp;</span><span class="keyword">as</span><span>&nbsp;&nbsp;&nbsp;varbinary(8000))&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@resultsp=(</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;@encrypted=1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;@resultsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;</span><span class="func">convert</span><span>(nvarchar(4000),</span><span class="func">case</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">when</span><span>&nbsp;&nbsp;&nbsp;@status&amp;2=2&nbsp;&nbsp;&nbsp;</span><span class="keyword">then</span><span>&nbsp;&nbsp;&nbsp;uncompress(@orgvarbin)&nbsp;&nbsp;&nbsp;</span><span class="keyword">else</span><span>&nbsp;&nbsp;&nbsp;@orgvarbin&nbsp;&nbsp;&nbsp;</span><span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>)&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;print&nbsp;&nbsp;&nbsp;@resultsp&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@n=@n+1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">set</span><span>&nbsp;&nbsp;&nbsp;@k=@k+1&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">drop</span><span>&nbsp;&nbsp;&nbsp;</span><span class="keyword">table</span><span>&nbsp;&nbsp;&nbsp;#</span><span class="keyword">temp</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">rollback</span><span>&nbsp;&nbsp;&nbsp;tran&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
    <li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></li>
    <li><span>&nbsp;&nbsp;<span class="keyword">end</span><span>&nbsp;&nbsp;&nbsp;&nbsp;</span></span></li>
</ol>
</div>
<p>调用方法：<span> <span class="keyword">exec</span><span>&nbsp;&nbsp;&nbsp;sp_decrypt&nbsp;&nbsp;&nbsp;</span><span class="string">'AppSP_test'</span><span>&nbsp;&nbsp;&nbsp; <br />
</span></span></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/81.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=81</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[GOOGLE/Baidu/Yahoo等六大搜索引擎博客RSS提交入口]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=8" label="SEO" /> 
	  <updated>2008-08-04T23:19:13+08:00</updated>
	  <published>2008-08-04T23:19:13+08:00</published>
		  <summary type="html"><![CDATA[<p>但凡写博的人都希望自己的博文能被更多的网友阅读，怎样才能达到这样的效果呢？ 精彩的原创文章至关重要，但仍旧需要良好的推广策略，才能更胜一筹，从而获得更多访客和流量。</p>
<p>各大搜索引擎提供的博客搜索服务就是我们推广博客的一个捷径。当下的博客发展可谓是蒸蒸日上，每天都有180,000个新的博客产生，也就是说每1秒钟，互联网就会产生2个新的博客，速度实在惊人。</p>
<p>随着博客再互联网上的地位不断的提高，各大搜索引擎纷纷推出了博客搜索功能。如果你的博客能被这些搜索引擎的博客搜索及时地抓取到索引库的话，这将会给你的博客带来更多的访客和流量，从而更快地提高你博客的知名度。如何才能被这些搜索引擎的博客搜索及时地抓取到呢？首要问题就是主动地让搜索引擎收录你的博客。</p>
<p>六大搜索引擎的博客提交入口列表如下：</p>
<p>1，Google博客收录：<a href="http://blogsearch.google.com/ping?hl=zh-CN"><font color="#006699">http://blogsearch.google.com/ping?hl=zh-CN</font></a> （独特的Ping 服务可以让你的博客内容收录的更快）</p>
<p>2，百度博客收录：<a href="http://utility.baidu.com/blogsearch/submit.php"><font color="#006699">http://utility.baidu.com/blogsearch/submit.php</font></a></p>
<p>3，雅虎博客收录：<a href="http://www.yahoo.cn/ex/blog_rss/rss_input.php"><font color="#006699">http://www.yahoo.cn/ex/blog_rss/rss_input.php</font></a>（RSS有一个好处是，能准确的提供信息，让博客在搜索引擎中有更好的展现，雅虎推荐使用RSS）</p>
<p>4，搜狗(搜狐)博客收录：<a href="http://www.sogou.com/feedback/blogfeedback.php"><font color="#006699">http://www.sogou.com/feedback/blogfeedback.php</font></a></p>
<p>5，新浪爱问博客收录：<a title="http://blog.iask.com/add_new_rss.php" href="http://blog.iask.com/add_new_rss.php"><font color="#006699">http://blog.iask.com/add_new_rss.php</font></a></p>
<p>博客有更新，立即通知爱问博客Ping服务：<a title="http://blog.iask.com/ping.php" href="http://blog.iask.com/ping.php"><font color="#006699">http://blog.iask.com/ping.php</font></a>（需支持RSS）</p>
<p>6，有道(163)博客收录：<a title="http://tellbot.yodao.com/report?type=BLOG&amp;keyFrom=help" href="http://tellbot.yodao.com/report?type=BLOG&amp;keyFrom=help"><font color="#006699">http://tellbot.yodao.com/report?type=BLOG&amp;keyFrom=help</font></a>(有道无法收录搜狐博客,够恨！)</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/80.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=80</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[最新版Sothink SWF Decompiler 4.2 80625 下载注册码]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=13" label="Graphic" /> 
	  <updated>2008-08-03T09:56:48+08:00</updated>
	  <published>2008-08-03T09:56:48+08:00</published>
		  <summary type="html"><![CDATA[<p>Sothink SWF Decompiler一款用于浏览和解析Flash动画（.swf文件和.exe文件）的工具。它能够将flash动画中的图片、矢量图、字体、文字、按钮、影片片段、帧等基 本元素完全分解，还可以对flash影片动作（Action）进行解析，清楚的显示其动作的代码，让您对Flash动画的构造一目了然。你可以将分解出来 的图片、矢量图、声音灵活应用于Sothink Glanda中，让你也可以做出大师级的作品！</p>
<p>软件下载地 址http://www.onlinedown.net/soft/27522.htm</p>
<p>&nbsp;</p>
<p>用户名:晕倒 /找不着<br />
注册码:031N8M-7P3A1X-03YV9U-AVZX6E-FYK73Q-A4K7PK-4E8Q1M-B3WRMA-83XHC9-WB1TUK-T7N719-NE4X3D</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/78.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=78</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[矢量图(ai/psd/cdr/eps)缩略图预览插件补丁下载]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=13" label="Graphic" /> 
	  <updated>2008-08-01T17:24:11+08:00</updated>
	  <published>2008-08-01T17:24:11+08:00</published>
		  <summary type="html"><![CDATA[做平面设计的朋友都熟悉，在XP系统系列 [我的电脑]与[资源管理器]中有好几种格式的文件是无法浏览缩略图的，只有在安装相应的软件以后，才可以在查看它们的缩略图，photoshop-CS2系列都没有了这个文件。<br/><br/>该补丁支持ai、psd、cdr、eps图片缩略图浏览功能。这个小补丁很实用，安装也很简单，依次点击，然后把注册表导入即可，装安后请重启电脑。<br/><br/>特别提示：重启电脑后才会生效<br/><img src="http://www.feiqiao.net/blog/images/download.gif" alt="下载文件" style="margin:0px 2px -4px 0px"/> <a href="http://www.feiqiao.net/blog/attachments/month_0810/z200810895341.rar" target="_blank">点击下载此文件</a><br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/79.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=79</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[autocad 2006 安装时发生严重错误[Error: 1603] ]]></title>
	  <author>
		 <name>biezhiyinan</name>
		 <uri>http://www.feiqiao.net/blog/</uri>
		 <email>bieyinan@gmail.com</email>
	  </author>
	  <category term="" scheme="http://www.feiqiao.net/blog/default.asp?cateID=13" label="Graphic" /> 
	  <updated>2008-07-24T21:39:10+08:00</updated>
	  <published>2008-07-24T21:39:10+08:00</published>
		  <summary type="html"><![CDATA[<p>autocad 2006 安装时发生严重错误[Error: 1603] ，报告如下：</p>
<p>[7/24/2008 21:24:59] === Installation started on YANG by Administrator ===<br />
[7/24/2008 21:25:01] [Info] Windows Installer upgrade is not required<br />
[7/24/2008 21:25:01]&nbsp;&nbsp; System Version = 3.1.4000.4039<br />
[7/24/2008 21:25:01] Installation skipped: MSI Runtime 3.0<br />
[7/24/2008 21:25:01] [Info] .NET Framework Runtime upgrade is not required<br />
[7/24/2008 21:25:01]&nbsp;&nbsp; System Version = 2.0.50727.42<br />
[7/24/2008 21:25:01] Installation skipped: .NET Framework Runtime 1.1<br />
[7/24/2008 21:25:01] Installation started: .NET Framework Runtime 1.1 Language Pack<br />
[7/24/2008 21:25:01]&nbsp;&nbsp; Command = &quot;E:\cad2006\CAD2006\Bin\AcadFEUI\support\dotnetfx\chs\langpack.exe&quot; /q:a /c:&quot;inst /qb&quot;<br />
[7/24/2008 21:25:02] [Error: 1603] 安装时发生严重错误<br />
[7/24/2008 21:25:02] Installation failed: .NET Framework Runtime 1.1 Language Pack<br />
[7/24/2008 21:25:02] Installation aborted<br />
[7/24/2008 21:31:06] === Installation ended ===<br />
上网查询后，说是需要安装Microsoft .NET Framework 1.1 <br />
&nbsp;</p>
<p>最佳解决方法：</p>
<p>进入E:\cad2006\CAD2006\Bin\acadFeui，盘符I随系统不同，就是AutoCAD2006安装文件所在盘符，直接运行&ldquo;acad.exe&rdquo;就可以安装了，而不需要再安装.NET Framework Runtime</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.feiqiao.net/blog/article/77.htm" /> 
	  <id>http://www.feiqiao.net/blog/default.asp?id=77</id>
  </entry>	
		
</feed>
