﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-DotNet菜园-最新评论</title><link>http://www.cnblogs.com/chillsrc/CommentsRSS.aspx</link><description>专注所以专业,专业所以专注</description><language>zh-cn</language><pubDate>Thu, 12 Apr 2012 05:36:57 GMT</pubDate><lastBuildDate>Thu, 12 Apr 2012 05:36:57 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:关于拼sql语句执行与直接执行存储过程的效率比较</title><link>http://www.cnblogs.com/chillsrc/archive/2012/01/06/2313685.html#2288186</link><dc:creator>nzperfect</dc:creator><author>nzperfect</author><pubDate>Fri, 06 Jan 2012 09:31:25 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2012/01/06/2313685.html#2288186</guid><description><![CDATA[其实不能这么来比较。
存储过程与拼SQL相比，主要还是提前编译，能够重用执行计划，大量的拼SQL会产生大量的编译，这个很耗CPU，在IO方面并不会有区别，当你的CPU数量不多，又有大量的SQL需要编译的时候，CPU的等待将会成为瓶颈，而存储过程不需重编译而省CPU消耗。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">nzperfect</a> 2012-01-06 17:31 <a href="http://www.cnblogs.com/chillsrc/archive/2012/01/06/2313685.html#2288186#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL语句练习实例之六——人事系统中的缺勤（休假）统计</title><link>http://www.cnblogs.com/chillsrc/archive/2011/11/10/2218311.html#2239943</link><dc:creator>eyye的眼睛</dc:creator><author>eyye的眼睛</author><pubDate>Thu, 10 Nov 2011 01:05:55 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/11/10/2218311.html#2239943</guid><description><![CDATA[这道题《SQL解惑》中有的<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">eyye的眼睛</a> 2011-11-10 09:05 <a href="http://www.cnblogs.com/chillsrc/archive/2011/11/10/2218311.html#2239943#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL语句练习实例之七——剔除不需要的记录行</title><link>http://www.cnblogs.com/chillsrc/archive/2011/10/25/2218337.html#2227208</link><dc:creator>玄德</dc:creator><author>玄德</author><pubDate>Tue, 25 Oct 2011 02:08:55 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/10/25/2218337.html#2227208</guid><description><![CDATA[存储过程中经常需要将某个表的所有字段列出组成字符串，在函数或select语句中引用。
我是写了个自定义的函数F_GetTableColumnName()，这样每次引用时相对方便：
delete from Employees where coalesce(F_GetTableColumnName(Employees)) is null<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">玄德</a> 2011-10-25 10:08 <a href="http://www.cnblogs.com/chillsrc/archive/2011/10/25/2218337.html#2227208#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql server 存储过程的优化.(变量表,临时表的简单分析)</title><link>http://www.cnblogs.com/chillsrc/archive/2011/10/23/877073.html#2225864</link><dc:creator>suinlove</dc:creator><author>suinlove</author><pubDate>Sun, 23 Oct 2011 13:18:29 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/10/23/877073.html#2225864</guid><description><![CDATA[这个未免也太片面了吧？表变量和临时表在不同情况下不同的优先使用规则的<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">suinlove</a> 2011-10-23 21:18 <a href="http://www.cnblogs.com/chillsrc/archive/2011/10/23/877073.html#2225864#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:WEB版一次选择多个文件进行批量上传(swfupload)的解决方案</title><link>http://www.cnblogs.com/chillsrc/archive/2011/10/14/1670594.html#2219603</link><dc:creator>lei0515</dc:creator><author>lei0515</author><pubDate>Fri, 14 Oct 2011 02:38:11 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/10/14/1670594.html#2219603</guid><description><![CDATA[怎么样进行大文件上传，我修改了web.config里对maxRequestLength的文件大小限制，但是好像还是不允许，出现了Server (IO) Error<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">lei0515</a> 2011-10-14 10:38 <a href="http://www.cnblogs.com/chillsrc/archive/2011/10/14/1670594.html#2219603#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL语句练习实例之一——找出最近的两次晋升日期与工资额</title><link>http://www.cnblogs.com/chillsrc/archive/2011/09/30/2195996.html#2211404</link><dc:creator>天门阿罪</dc:creator><author>天门阿罪</author><pubDate>Fri, 30 Sep 2011 01:35:21 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/09/30/2195996.html#2211404</guid><description><![CDATA[学习学习啊<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">天门阿罪</a> 2011-09-30 09:35 <a href="http://www.cnblogs.com/chillsrc/archive/2011/09/30/2195996.html#2211404#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:WEB版一次选择多个文件进行批量上传(swfupload)的解决方案</title><link>http://www.cnblogs.com/chillsrc/archive/2011/09/22/1670594.html#2205321</link><dc:creator>元叶</dc:creator><author>元叶</author><pubDate>Thu, 22 Sep 2011 07:45:38 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/09/22/1670594.html#2205321</guid><description><![CDATA[flash_url : &quot;../swfupload/swfupload.swf&quot;,

这句话改成 flash_url : &quot;swfupload/swfupload.swf&quot;,
就可以看到选择文件的按钮了，版主把路径搞错了，有兴趣联系360429603聊聊..........<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">元叶</a> 2011-09-22 15:45 <a href="http://www.cnblogs.com/chillsrc/archive/2011/09/22/1670594.html#2205321#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:数据库优化方法(二)</title><link>http://www.cnblogs.com/chillsrc/archive/2011/07/28/1571444.html#2163087</link><dc:creator>szny</dc:creator><author>szny</author><pubDate>Thu, 28 Jul 2011 05:42:17 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/07/28/1571444.html#2163087</guid><description><![CDATA[.net 简约而不简单。 真理！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">szny</a> 2011-07-28 13:42 <a href="http://www.cnblogs.com/chillsrc/archive/2011/07/28/1571444.html#2163087#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:无法启动调试--未安装 Silverlight Developer 运行时。请安装一个匹配版本。</title><link>http://www.cnblogs.com/chillsrc/archive/2011/07/22/1766816.html#2158261</link><dc:creator>KangPeng</dc:creator><author>KangPeng</author><pubDate>Fri, 22 Jul 2011 06:45:54 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/07/22/1766816.html#2158261</guid><description><![CDATA[先Mark一下<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">KangPeng</a> 2011-07-22 14:45 <a href="http://www.cnblogs.com/chillsrc/archive/2011/07/22/1766816.html#2158261#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:WEB版一次选择多个文件进行批量上传(swfupload)的解决方案</title><link>http://www.cnblogs.com/chillsrc/archive/2011/06/26/1670594.html#2135562</link><dc:creator>jiao+f</dc:creator><author>jiao+f</author><pubDate>Sun, 26 Jun 2011 10:36:13 GMT</pubDate><guid>http://www.cnblogs.com/chillsrc/archive/2011/06/26/1670594.html#2135562</guid><description><![CDATA[[quote]zjhzjh：运行后怎么看不到“选择文件”那个按钮？[/quote]
我的也是啊，请楼主解释一下啊！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/chillsrc/" target="_blank">jiao+f</a> 2011-06-26 18:36 <a href="http://www.cnblogs.com/chillsrc/archive/2011/06/26/1670594.html#2135562#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
