<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title>小锋博客</title>
		<link>http://www.jackfeng.com/</link>
		<description></description>
		<copyright>Copyright (C) 2004 Security Angel Team [S4T] All Rights Reserved.</copyright>
		<generator>SaBlog-X Version Plus 2.0 Build 20081001</generator>
		<lastBuildDate>Sat, 22 Nov 2008 07:40:17 +0000</lastBuildDate>
		<ttl>30</ttl>
		<item>
			<guid>http://www.jackfeng.com/show-1265-1.html</guid>
			<title>eclipse快捷键大全</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>eclipse快捷键大全</p><br /><br /><a href="http://www.jackfeng.com/show-1265-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.jackfeng.com/show-1265-1.html</link>
			<category domain="http://www.jackfeng.com/category/16/">PHP</category>
			<pubDate>2008-11-21 18:51</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1264-1.html</guid>
			<title>frame 透明</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p><span style="color: #ff0000">allowTransparency=&quot;true&quot;</span></p>
<p>因为页面调用大型图片显示比较慢 所以用了frame来加快显示其它页面 正好用到frame要透明</p>]]></description>
			<link>http://www.jackfeng.com/show-1264-1.html</link>
			<category domain="http://www.jackfeng.com/category/7/">电脑</category>
			<pubDate>2008-11-21 15:56</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1263-1.html</guid>
			<title>Linux删除目录命令</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p><span style="color: #ff0000">rm -rf hjol</span></p>
<p>r是目录的意思 f是忽略啥的意思</p>]]></description>
			<link>http://www.jackfeng.com/show-1263-1.html</link>
			<category domain="http://www.jackfeng.com/category/20/">Linux</category>
			<pubDate>2008-11-21 11:30</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1262-1.html</guid>
			<title>设置Apache虚拟目录</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>&nbsp;</p>
<p>打开Apache的配置文件httpd.conf</p>
<p>如下加上：<span style="color: #ff0000">&nbsp;Alias /uploads/ &quot;D:/uploads/&quot;</span></p>
<pre><ol class="dp-xml"><li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">VirtualHost</span><span>&nbsp;*:80&nbsp;</span><span class="tag">&gt;</span><span>&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;ServerAdmin&nbsp;dlf@msn.cn &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;DocumentRoot&nbsp;D:\htdocs &nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;Alias&nbsp;/uploads/&nbsp;&quot;D:/uploads/&quot; &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;ServerName&nbsp;&nbsp;w.jackfeng.com &nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;AddDefaultCharset&nbsp;UTF-8&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</span></li><li class="alt"><span class="tag">&lt;/</span><span class="tag-name">VirtualHost</span><span class="tag">&gt;</span><span>&nbsp; &nbsp;</span></li></ol></pre>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1262-1.html</link>
			<category domain="http://www.jackfeng.com/category/7/">电脑</category>
			<pubDate>2008-11-21 10:49</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1261-1.html</guid>
			<title>php删除目录 复制目录 判断目录是否为空</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>php删除目录 复制目录 判断目录是否为空~~~~~~~~</p><br /><br /><a href="http://www.jackfeng.com/show-1261-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.jackfeng.com/show-1261-1.html</link>
			<category domain="http://www.jackfeng.com/category/16/">PHP</category>
			<pubDate>2008-11-20 17:39</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1260-1.html</guid>
			<title>php中判断一个字符串包含另一个字符串的方法</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>php中判断一个字符串包含另一个字符串的方法</p>
<pre><ol class="dp-c"><li class="alt"><span><span class="vars">$name</span><span>&nbsp;=&nbsp;</span><span class="string">&quot;001x.gif&quot;</span><span>;&nbsp; &nbsp;</span></span></li><li><span class="vars">$pan</span><span>&nbsp;=&nbsp;</span><span class="string">&quot;x&quot;</span><span>;&nbsp; &nbsp;</span></li><li class="alt"><span class="vars">$con</span><span>&nbsp;=&nbsp;</span><span class="func">explode</span><span>(</span><span class="vars">$pan</span><span>,</span><span class="vars">$name</span><span>);&nbsp; &nbsp;</span></li><li><span class="keyword">if</span><span>&nbsp;(</span><span class="func">count</span><span>(</span><span class="vars">$con</span><span>)&gt;1):&nbsp; &nbsp;</span></li><li class="alt"><span class="func">echo</span><span>&nbsp;</span><span class="vars">$name</span><span>.</span><span class="string">&quot;中包含&quot;</span><span>.</span><span class="vars">$pan</span><span>;&nbsp; &nbsp;</span></li><li><span class="keyword">else</span><span>:&nbsp; &nbsp;</span></li><li class="alt"><span class="func">echo</span><span>&nbsp;</span><span class="vars">$name</span><span>.</span><span class="string">&quot;中没有包含&quot;</span><span>.</span><span class="vars">$pan</span><span>;&nbsp; &nbsp;</span></li><li><span class="keyword">endif</span><span>;&nbsp;&nbsp;</span></li></ol></pre>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1260-1.html</link>
			<category domain="http://www.jackfeng.com/category/16/">PHP</category>
			<pubDate>2008-11-17 17:57</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1259-1.html</guid>
			<title>js 下移input 内容框的内容</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>&lt;a href=&quot;javascript:;&quot; onclick=&quot;moveDown()&quot;&gt;&lt;font color=&quot;green&quot;&gt;文章下移&lt;/font&gt;</p>
<p>后台INPUT输入框经常会更换文章太麻烦了 老是复制来复制去</p>
<p>早就想丢一个js过去自动一个一个移到下面了 不会JS没办法 只能瞎写一个了</p>
<pre><ol class="dp-c"><li class="alt"><span><span>&lt;script&nbsp;language=</span><span class="string">&quot;javascript&quot;</span><span>&gt; &nbsp;</span></span></li><li><span class="keyword">function</span><span>&nbsp;moveDown()&nbsp;{ &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="keyword">for</span><span>&nbsp;(</span><span class="keyword">var</span><span>&nbsp;i&nbsp;=&nbsp;8;&nbsp;i&nbsp;&gt;&nbsp;1&nbsp;;i--&nbsp;){ &nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;document.getElementById(</span><span class="string">&quot;N&quot;</span><span>+i+</span><span class="string">&quot;#title&quot;</span><span>).value=document.getElementById(</span><span class="string">&quot;N&quot;</span><span>+(i-1)+</span><span class="string">&quot;#title&quot;</span><span>).value; &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;document.getElementById(</span><span class="string">&quot;N&quot;</span><span>+i+</span><span class="string">&quot;#url&quot;</span><span>).value=document.getElementById(</span><span class="string">&quot;N&quot;</span><span>+(i-1)+</span><span class="string">&quot;#url&quot;</span><span>).value; &nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;} &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;document.getElementById(</span><span class="string">&quot;N1#title&quot;</span><span>).value=</span><span class="string">&quot;&quot;</span><span>; &nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;document.getElementById(</span><span class="string">&quot;N1#url&quot;</span><span>).value=</span><span class="string">&quot;&quot;</span><span>; &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</span></li><li><span>} &nbsp;</span></li><li class="alt"><span>&lt;/script&gt;&nbsp;</span></li></ol></pre>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1259-1.html</link>
			<category domain="http://www.jackfeng.com/category/26/">JS</category>
			<pubDate>2008-11-17 16:55</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1258-1.html</guid>
			<title>getElementsByName和document.getElementById</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <div class="content">　　这两个很有趣<br />
　　注意getElementsByName 有s在里面<br />
　　document.getElementById()可以控制某个id的tag<br />
　　document.getElementsByName()，返回的是一个具有相同 name 属性的元素的集合，而不是某个，注意有&ldquo;s&rdquo;。 <br />
　　<br />
　　而 document.getElementsByTagName() 返回的是一组相同 TAG 的元素集合。<br />
　　<br />
　　同一个name可以有多个element，所以用document.getElementsByName(&quot;theName&quot;)<br />
　　他return 一个collection，引用的时候要指名index<br />
　　var test = document.getElementsByName('testButton')[0];<br />
　　<br />
　　id那个，是唯一的</div>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1258-1.html</link>
			<category domain="http://www.jackfeng.com/category/26/">JS</category>
			<pubDate>2008-11-17 16:25</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1257-1.html</guid>
			<title>SaBlog2.0增加Delphi语法着色</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>修改你的博客下面<span style="color: #ff0000">\include\editor\editor\dialog\fck_codes.html</span>这个文件</p>
<p>记得下面这个代码不要把Delphi和delphi搞错</p>
<p>这两个是区分开来的-_-#我改成value=&quot;Delphi&quot;就不行</p>
<pre><ol class="dp-xml"><li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">option</span><span>&nbsp;</span><span class="attribute">value</span><span>=</span><span class="attribute-value">&quot;delphi&quot;</span><span class="tag">&gt;</span><span>delphi</span><span class="tag">&lt;/</span><span class="tag-name">option</span><span class="tag">&gt;</span><span>&nbsp;</span></span></li></ol></pre>
<p>然后就可以啦 由于ie有缓存</p>
<p>所以最好打开 你的博客的比如<a href="http://www.jackfeng.com/include/editor/editor/dialog/fck_codes.html">http://www.jackfeng.com/include/editor/editor/dialog/fck_codes.html</a></p>
<p>打开刷新一下 然后看看你的编辑器就能正常的用delphi语法着色了</p><br /><br /><b>图片附件:</b><br /><a href="http://www.jackfeng.com/attachment.php?id=732" target="_blank"><img src="http://www.jackfeng.com/attachments//date_200811/12187f478b3bad10039bcdc48972bca6.gif" border="0" alt="大小: 6.26 K&#13;尺寸: 400 x 85&#13;浏览: 19 次&#13;点击打开新窗口浏览全图" width="400" height="85" /></a>]]></description>
			<link>http://www.jackfeng.com/show-1257-1.html</link>
			<category domain="http://www.jackfeng.com/category/7/">电脑</category>
			<pubDate>2008-11-16 17:25</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1256-1.html</guid>
			<title>ShowModal返回信息 窗体弹出后的返回值</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <pre><ol class="dp-delphi"><li class="alt"><span><span>Var &nbsp;</span></span></li><li><span>&nbsp;&nbsp;SetFrm&nbsp;:TSetes; &nbsp;</span></li><li class="alt"><span class="keyword">begin</span><span>&nbsp;</span></li><li><span>&nbsp;&nbsp;SetFrm&nbsp;:=TSetes</span><span class="number">.</span><span>Create(</span><span class="keyword">nil</span><span>); &nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;SetFrm</span><span class="number">.</span><span>ShowModal; &nbsp;</span></li><li><span>&nbsp;&nbsp;</span><span class="keyword">if</span><span>&nbsp;SetFrm</span><span class="number">.</span><span>ModalResult&nbsp;=</span><span class="number">2</span><span>&nbsp;</span><span class="keyword">then</span><span>&nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;ShowMessage(</span><span class="string">'配置重载成功！'</span><span>); &nbsp;</span></li><li class="alt"><span class="keyword">end</span><span>;&nbsp;&nbsp;</span></li></ol></pre>
<p>窗体弹出后需要接触到确认与取消按钮 modalresult&nbsp;:=mrOK能返回1 modalresult :=mrCancel能返回2</p><br /><br /><b>图片附件:</b><br /><a href="http://www.jackfeng.com/attachment.php?id=731" target="_blank"><img src="http://www.jackfeng.com/attachments//date_200811/59dcf07868d1d2e867a34127296da84e.gif" border="0" alt="大小: 22.91 K&#13;尺寸: 400 x 85&#13;浏览: 23 次&#13;点击打开新窗口浏览全图" width="400" height="85" /></a>]]></description>
			<link>http://www.jackfeng.com/show-1256-1.html</link>
			<category domain="http://www.jackfeng.com/category/12/">DELPHI</category>
			<pubDate>2008-11-16 16:33</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1255-1.html</guid>
			<title>telnet 乱码问题 设置big5即可</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>由于telnet bbs.sayya.org直接这么用cmd进去的话 会乱码 cmd有一些属性可以做调整</p>
<p>先在桌面上建立一个cmd.exe的快捷方式</p>
<p><span>然后打开属性 你会看到一个选项：当前代码页 在里面选择950的BIG5</span></p>
<p><span>这个选择好了还没有完成 这样你telnet bbs.sayya.org还是会乱 这个是因为你的字体太小了 无法显示正常</span></p>
<p><span>所以再设置一下字体弄大点就Finish了</span></p>]]></description>
			<link>http://www.jackfeng.com/show-1255-1.html</link>
			<category domain="http://www.jackfeng.com/category/7/">电脑</category>
			<pubDate>2008-11-16 14:00</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1254-1.html</guid>
			<title>SQL2000装不上 提示安装程序配置服务器失败</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>安装程序配置服务器失败。参考服务器错误日志和 C:\WINDOWS\sqlstp.log 了解更多信息。</p>
<p>这个问题-_-#以前碰到过 没能解决。。这次装2000又碰到了 重复安装 还是不行</p>
<p>但是更换了实例名就可以了。。。可是更换了实例名 TMD SP4打上就把sql2000给挂掉了</p>
<p>不得不又重新安装</p>
<p><span style="color: #ff0000">最终的办法就是一不做二不休 把sql2000的遗留清理干净。</span></p>
<p>1.注册表的清理</p>
<p>里面的Microsoft SQL Server相关都干掉</p>
<p>2.文件清理</p>
<p>C:\Program Files\Microsoft SQL Server干掉</p>
<p>C:\Program Files\Common Files\Microsoft Shared能干掉就干掉</p>
<p>再装上试试就搞定了 记得清理干净 不然想装的好 那是不可能的。</p>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1254-1.html</link>
			<category domain="http://www.jackfeng.com/category/25/">SQL</category>
			<pubDate>2008-11-15 13:01</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1253-1.html</guid>
			<title>删除 SQL 2000 实例名</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>微软的 一篇关于SQL2000的实例名删除操作</p><br /><br /><a href="http://www.jackfeng.com/show-1253-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.jackfeng.com/show-1253-1.html</link>
			<category domain="http://www.jackfeng.com/category/25/">SQL</category>
			<pubDate>2008-11-15 11:47</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1252-1.html</guid>
			<title>delphi 窗体最小化问题</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>ShowWindow(Application.Handle ,SW_SHOWMINIMIZED),</p>
<p>用API的不好使</p>
<p>最好不要直接用API，Delphi的窗体（主窗体）是比较特殊的。 <br />
1.如果是整个程序要最小化，请使用：Application.Minimize; 恢复使用：Application.Restore; <br />
2.如果是某个窗体要最小化，请使用类似：Form1.WindowState := wsMinimized;最大化使用Form1.WindowState := wsMaximized;恢复正常使用Form1.WindowState := wsNormal;</p>]]></description>
			<link>http://www.jackfeng.com/show-1252-1.html</link>
			<category domain="http://www.jackfeng.com/category/12/">DELPHI</category>
			<pubDate>2008-11-14 21:43</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1251-1.html</guid>
			<title>检测完表单 自动提交</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>ajax检测完 让它自动提交表单</p>
<pre><ol class="dp-c"><li class="alt"><span><span>window.document.forms[0].submit.click();&nbsp;</span></span></li></ol></pre>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1251-1.html</link>
			<category domain="http://www.jackfeng.com/category/26/">JS</category>
			<pubDate>2008-11-14 14:52</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1250-1.html</guid>
			<title>php 获得前一个月的月份</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>&nbsp;</p>
<pre><ol class="dp-c"><li class="alt"><span><span class="func">date</span><span>(</span><span class="string">&quot;Y.m&quot;</span><span>,</span><span class="func">strtotime</span><span>(</span><span class="string">&quot;-31&nbsp;days&quot;</span><span>)) &nbsp;</span></span></li></ol></pre>
<p>&nbsp;</p>]]></description>
			<link>http://www.jackfeng.com/show-1250-1.html</link>
			<category domain="http://www.jackfeng.com/category/16/">PHP</category>
			<pubDate>2008-11-14 14:39</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1249-1.html</guid>
			<title>关系数据库性能问题</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>15. 减少对表的查询 <br />
在含有子查询的SQL语句中,要特别注意减少对表的查询. <br />
&nbsp; 例如:&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp; Slow:<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT TAB_NAME <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM TABLES <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE TAB_NAME = ( SELECT TAB_NAME&nbsp; <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; FROM TAB_COLUMNS <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; WHERE VERSION = 604) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND　DB_VER= ( SELECT DB_VER&nbsp; <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; FROM TAB_COLUMNS <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; WHERE VERSION = 604)</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; Fast:<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT TAB_NAME <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM TABLES <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; (TAB_NAME,DB_VER) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = ( SELECT TAB_NAME,DB_VER)&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM TAB_COLUMNS <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE VERSION = 604)</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; Update 多个Column 例子: <br />
&nbsp;&nbsp;&nbsp;&nbsp; Slow<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPDATE EMP <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET EMP_CAT = (SELECT MAX(CATEGORY) FROM EMP_CATEGORIES), <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SAL_RANGE = (SELECT MAX(SAL_RANGE) FROM EMP_CATEGORIES) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE EMP_DEPT = 0020;</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; Fast<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPDATE EMP <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET (EMP_CAT, SAL_RANGE) <br />
&nbsp;= (SELECT MAX(CATEGORY) , MAX(SAL_RANGE) <br />
&nbsp;FROM EMP_CATEGORIES) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE EMP_DEPT = 0020;</p>
<p>&nbsp;</p>
<p>8. 使用DECODE函数来减少处理时间 <br />
使用DECODE函数可以避免重复扫描相同记录或重复连接相同的表. <br />
例如: <br />
&nbsp;&nbsp; SELECT COUNT(*)，SUM(SAL) <br />
&nbsp;&nbsp; FROM　EMP <br />
&nbsp;&nbsp; WHERE DEPT_NO = 0020 <br />
&nbsp;&nbsp; AND ENAME LIKE　&lsquo;SMITH%&rsquo;; <br />
&nbsp;&nbsp; SELECT COUNT(*)，SUM(SAL) <br />
&nbsp;&nbsp; FROM　EMP <br />
&nbsp;&nbsp; WHERE DEPT_NO = 0030 <br />
&nbsp;&nbsp; AND ENAME LIKE　&lsquo;SMITH%&rsquo;; <br />
你可以用DECODE函数高效地得到相同结果 <br />
SELECT COUNT(DECODE(DEPT_NO,0020,&rsquo;X&rsquo;,NULL)) D0020_COUNT, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNT(DECODE(DEPT_NO,0030,&rsquo;X&rsquo;,NULL)) D0030_COUNT, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUM(DECODE(DEPT_NO,0020,SAL,NULL)) D0020_SAL, <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUM(DECODE(DEPT_NO,0030,SAL,NULL)) D0030_SAL <br />
FROM EMP WHERE ENAME LIKE &lsquo;SMITH%&rsquo;; <br />
类似的,DECODE函数也可以运用于GROUP BY 和ORDER BY子句中.</p>]]></description>
			<link>http://www.jackfeng.com/show-1249-1.html</link>
			<category domain="http://www.jackfeng.com/category/25/">SQL</category>
			<pubDate>2008-11-10 17:26</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1248-1.html</guid>
			<title>my97 日期控件很不错 调用方便</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>演示地址：<a href="http://www.my97.net/dp/demo/">http://www.my97.net/dp/demo/</a></p>
<p>My97 DatePicker 4.0 正式版 发布</p>
<p><u><font color="#0000ff"><a href="http://blog.csdn.net/My97/archive/2008/10/29/3173524.aspx">http://blog.csdn.net/My97/archive/2008/10/29/3173524.aspx</a></font></u></p><br /><br /><b>图片附件:</b><br /><a href="http://www.jackfeng.com/attachment.php?id=730" target="_blank"><img src="http://www.jackfeng.com/attachments//date_200811/741af284071d88a5f041d10eb5d0a285.jpg" border="0" alt="大小: 19.82 K&#13;尺寸: 85 x 92&#13;浏览: 54 次&#13;点击打开新窗口浏览全图" width="85" height="92" /></a>]]></description>
			<link>http://www.jackfeng.com/show-1248-1.html</link>
			<category domain="http://www.jackfeng.com/category/26/">JS</category>
			<pubDate>2008-11-07 22:00</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1247-1.html</guid>
			<title>所在地JS 调用很方便</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>&lt;script language=&quot;javascript&quot; type=&quot;text/javascript&quot; src=&quot;js/area_expand.js&quot;&gt;&lt;/script&gt;</p>
<p>js文件打包在附件中。</p>
<pre><ol class="dp-xml"><li class="alt"><span><span class="tag">&lt;</span><span class="tag-name">select</span><span>&nbsp;</span><span class="attribute">id</span><span>=</span><span class="attribute-value">province</span><span>&nbsp;</span><span class="attribute">name</span><span>=</span><span class="attribute-value">&quot;province&quot;</span><span>&nbsp;</span><span class="attribute">onchange</span><span>=</span><span class="attribute-value">&quot;citys(this,'')&quot;</span><span class="tag">&gt;</span><span class="tag">&lt;/</span><span class="tag-name">select</span><span class="tag">&gt;</span><span>&amp;nbsp;</span><span class="tag">&lt;</span><span class="tag-name">select</span><span>&nbsp;</span><span class="attribute">id</span><span>=</span><span class="attribute-value">city</span><span>&nbsp;</span><span class="attribute">name</span><span>=</span><span class="attribute-value">&quot;city&quot;</span><span class="tag">&gt;</span><span class="tag">&lt;/</span><span class="tag-name">select</span><span class="tag">&gt;</span><span>&nbsp;</span></span></li><li><span class="tag">&lt;</span><span class="tag-name">script</span><span class="tag">&gt;</span><span>&nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;province('浙江','温州'); &nbsp;</span></li><li><span class="tag">&lt;/</span><span class="tag-name">script</span><span class="tag">&gt;</span><span>&nbsp;</span></li></ol></pre>
<p>&nbsp;</p><br /><br /><b>附件: </b><a href="http://www.jackfeng.com/attachment.php?id=729" target="_blank">area_expand.rar</a> (2.94 K, 下载次数:57)]]></description>
			<link>http://www.jackfeng.com/show-1247-1.html</link>
			<category domain="http://www.jackfeng.com/category/26/">JS</category>
			<pubDate>2008-11-07 20:11</pubDate>
		</item>
		<item>
			<guid>http://www.jackfeng.com/show-1246-1.html</guid>
			<title>linux下定时执行计划任务</title>
			<author>小锋</author>
			<description><![CDATA[小锋博客 ( http://www.jackfeng.com/ ) : <p>服务器上经常会卡一下 原来是计划任务的关系&nbsp; 没办法 只能接触一下这个了。</p><br /><br /><a href="http://www.jackfeng.com/show-1246-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.jackfeng.com/show-1246-1.html</link>
			<category domain="http://www.jackfeng.com/category/20/">Linux</category>
			<pubDate>2008-11-07 15:51</pubDate>
		</item>
	</channel>
</rss>
