﻿<?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>博客园-一叶知秋 一屑知城-最新评论</title><link>http://www.cnblogs.com/icebutterfly/CommentsRSS.aspx</link><description>每天都不能停止前进的脚步</description><language>zh-cn</language><pubDate>Tue, 13 Mar 2012 02:30:25 GMT</pubDate><lastBuildDate>Tue, 13 Mar 2012 02:30:25 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:使用NCover协同NUnit一起工作</title><link>http://www.cnblogs.com/icebutterfly/archive/2012/03/02/1351795.html#2321161</link><dc:creator>baibin</dc:creator><author>baibin</author><pubDate>Fri, 02 Mar 2012 02:18:58 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2012/03/02/1351795.html#2321161</guid><description><![CDATA[求更祥细的配置  和步骤。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">baibin</a> 2012-03-02 10:18 <a href="http://www.cnblogs.com/icebutterfly/archive/2012/03/02/1351795.html#2321161#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:.chm文件打开后里面没有内容 错误页面“此程序无法显示网页”</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/12/22/1591317.html#2276971</link><dc:creator>vv_apple</dc:creator><author>vv_apple</author><pubDate>Thu, 22 Dec 2011 09:34:20 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/12/22/1591317.html#2276971</guid><description><![CDATA[thank you! i get it.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">vv_apple</a> 2011-12-22 17:34 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/12/22/1591317.html#2276971#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:问题：No VSS database (srcsafe.ini) found. Use the SSDIR environment variable or run netsetup</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/12/04/1371631.html#2261180</link><dc:creator>Anders.lu</dc:creator><author>Anders.lu</author><pubDate>Sun, 04 Dec 2011 12:07:03 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/12/04/1371631.html#2261180</guid><description><![CDATA[@冰碟，您好能跟您交流一下，我的总是报No VSS database (srcsafe.ini) found. Use the SSDIR environment variable or run netsetup错误，我也设置了服务的运行账户，可是还不行，希望得到您的帮户，我qq：815744981，谢谢。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">Anders.lu</a> 2011-12-04 20:07 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/12/04/1371631.html#2261180#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:IIS 错误：Unexpected error 0x8ffe2740 occurred</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/11/08/1393909.html#2238207</link><dc:creator>猪头</dc:creator><author>猪头</author><pubDate>Tue, 08 Nov 2011 01:53:56 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/11/08/1393909.html#2238207</guid><description><![CDATA[Thanks<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">猪头</a> 2011-11-08 09:53 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/11/08/1393909.html#2238207#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server中DataLength()与Len()的区别</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/08/05/1946385.html#2169645</link><dc:creator>GreenHandwm</dc:creator><author>GreenHandwm</author><pubDate>Fri, 05 Aug 2011 06:19:15 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/08/05/1946385.html#2169645</guid><description><![CDATA[DATALENGTH() 函数返回的是列所占用的字节数；
char()和nchar()都是固定长度的；也就是大小是固定的，申明了长度，但没填满时后面就是空格，也算在内了！
字符类型前面带var的都是可变长度的，这时用datalength()返回的就是实际值的长度；
另外值得注意的是 当字符数据类型是ntext text..等类型时，用len()好像会报错，望楼主研究哈 ,最好能将成果贴在博客上面！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">GreenHandwm</a> 2011-08-05 14:19 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/08/05/1946385.html#2169645#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server中DataLength()与Len()的区别</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/02/09/1946385.html#2023213</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Wed, 09 Feb 2011 04:57:13 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/02/09/1946385.html#2023213</guid><description><![CDATA[@Vincent Yang
呵呵，有道理！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2011-02-09 12:57 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/02/09/1946385.html#2023213#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL Server中DataLength()与Len()的区别</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/01/27/1946385.html#2019873</link><dc:creator>Vincent Yang</dc:creator><author>Vincent Yang</author><pubDate>Thu, 27 Jan 2011 10:11:21 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/01/27/1946385.html#2019873</guid><description><![CDATA[你这不是折腾自己么，其实只要知道len和datalength的区别你就清楚了，len这个函数是不包括trailing space的，而datalength是把character和trailing space都计算在内的，剩下的就很明显了，你只需要明白varchar和char的区别还有nxxx的区别就知道为什么后面是3，40，20了<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">Vincent Yang</a> 2011-01-27 18:11 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/01/27/1946385.html#2019873#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:问题：String or binary data would be truncated</title><link>http://www.cnblogs.com/icebutterfly/archive/2011/01/21/1353754.html#2016367</link><dc:creator>finesite</dc:creator><author>finesite</author><pubDate>Fri, 21 Jan 2011 12:41:45 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2011/01/21/1353754.html#2016367</guid><description><![CDATA[谢谢果然如此 ！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">finesite</a> 2011-01-21 20:41 <a href="http://www.cnblogs.com/icebutterfly/archive/2011/01/21/1353754.html#2016367#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:限制文本框输入的内容</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/12/11/1369285.html#1985175</link><dc:creator>Oyes</dc:creator><author>Oyes</author><pubDate>Sat, 11 Dec 2010 15:51:53 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/12/11/1369285.html#1985175</guid><description><![CDATA[正则表达式<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">Oyes</a> 2010-12-11 23:51 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/12/11/1369285.html#1985175#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:限制文本框输入的内容</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/11/30/1369285.html#1973100</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Tue, 30 Nov 2010 06:23:58 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/11/30/1369285.html#1973100</guid><description><![CDATA[@Oyes
是呀。出现bug了。请问有什么解决方案吗？<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2010-11-30 14:23 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/11/30/1369285.html#1973100#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:限制文本框输入的内容</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/11/29/1369285.html#1971900</link><dc:creator>Oyes</dc:creator><author>Oyes</author><pubDate>Mon, 29 Nov 2010 09:19:19 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/11/29/1369285.html#1971900</guid><description><![CDATA[嘿嘿，切换到全角就不行了。。。。。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">Oyes</a> 2010-11-29 17:19 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/11/29/1369285.html#1971900#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:问题：String or binary data would be truncated</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/10/19/1353754.html#1937693</link><dc:creator>王思源</dc:creator><author>王思源</author><pubDate>Tue, 19 Oct 2010 02:19:41 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/10/19/1353754.html#1937693</guid><description><![CDATA[谢谢，解决了我的问题<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">王思源</a> 2010-10-19 10:19 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/10/19/1353754.html#1937693#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:C#四舍五入问题</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/06/10/1369291.html#1844412</link><dc:creator>James-yu</dc:creator><author>James-yu</author><pubDate>Wed, 09 Jun 2010 16:23:41 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/06/10/1369291.html#1844412</guid><description><![CDATA[c#是取最接近的数字，你把数字转换为2进制看看，那个最接近<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">James-yu</a> 2010-06-10 00:23 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/06/10/1369291.html#1844412#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SilverLight 2中的WatermarkedTextBox控件</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/05/06/1446086.html#1817516</link><dc:creator>咸鱼翻身</dc:creator><author>咸鱼翻身</author><pubDate>Thu, 06 May 2010 02:19:17 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/05/06/1446086.html#1817516</guid><description><![CDATA[2是没有这个属性<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">咸鱼翻身</a> 2010-05-06 10:19 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/05/06/1446086.html#1817516#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:ROW_NUMBER() OVER函数的基本用法用法</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792095</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Thu, 01 Apr 2010 08:54:13 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792095</guid><description><![CDATA[@MichaelJiang
呵呵，客气了。一起学习。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2010-04-01 16:54 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792095#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:ROW_NUMBER() OVER函数的基本用法用法</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792089</link><dc:creator>MichaelJiang</dc:creator><author>MichaelJiang</author><pubDate>Thu, 01 Apr 2010 08:51:26 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792089</guid><description><![CDATA[理解了！3q<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">MichaelJiang</a> 2010-04-01 16:51 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/04/01/1539657.html#1792089#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL中IF语句的问题【高手请进】</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/02/08/1662496.html#1762683</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Mon, 08 Feb 2010 03:31:36 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/02/08/1662496.html#1762683</guid><description><![CDATA[@Vincent Yang
哦，原来如此，清晰些了！3Q<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2010-02-08 11:31 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/02/08/1662496.html#1762683#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL中IF语句的问题【高手请进】</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/02/04/1662496.html#1760274</link><dc:creator>Vincent Yang</dc:creator><author>Vincent Yang</author><pubDate>Thu, 04 Feb 2010 01:53:33 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/02/04/1662496.html#1760274</guid><description><![CDATA[The reason you get true is if you compare '' to 0, they are not same type, sql server will auto use len function to evaluate that varchar/char value first. Empty's length is 0, convert to native execution it will look like len('') = 0, that's why it will return true.<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">Vincent Yang</a> 2010-02-04 09:53 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/02/04/1662496.html#1760274#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL中IF语句的问题【高手请进】</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759778</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Wed, 03 Feb 2010 05:51:25 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759778</guid><description><![CDATA[@清海扬波
是TRUE我写错了，不好意思。你的意思是要讲''转换为int型。
我试了试，果然是这样。
SELECT cast('' AS int) 返回的果然是0。原来如此。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2010-02-03 13:51 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759778#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL中IF语句的问题【高手请进】</title><link>http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759764</link><dc:creator>冰碟</dc:creator><author>冰碟</author><pubDate>Wed, 03 Feb 2010 05:41:34 GMT</pubDate><guid>http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759764</guid><description><![CDATA[@滔滔踏浪
是Sql Server<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/icebutterfly/" target="_blank">冰碟</a> 2010-02-03 13:41 <a href="http://www.cnblogs.com/icebutterfly/archive/2010/02/03/1662496.html#1759764#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
