Thu, 14 May 2009 23:40:00 GMT近身剪http://blog.csdn.net/jinjazz/http://blog.csdn.net/jinjazz/archive/2009/05/14/4187051.aspxhttp://blog.csdn.net/jinjazz/comments/4187051.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4187051.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4187051我们可以用CLR获取网络服务 来显示到数据库自定函数的结果集中，比如163的天气预报<img src ="http://blog.csdn.net/jinjazz/aggbug/4187051.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/223705428/jinjazz/csdn.net/s.gif?r=http://blog.csdn.net/jinjazz/archive/2009/05/14/4187051.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705428/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705428/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 15 May 2009 07:40:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/05/14/4187051.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/05/14/4187051.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/05/14/4187051.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705428/1115428http://blog.csdn.net/jinjazz/archive/2009/05/12/4171831.aspxhttp://blog.csdn.net/jinjazz/comments/4171831.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4171831.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4171831用Microsoft.VisualBasic命名空间下强大的字符串处理函数就可以了<img src ="http://blog.csdn.net/jinjazz/aggbug/4171831.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/223705429/jinjazz/csdn.net/s.gif?r=http://blog.csdn.net/jinjazz/archive/2009/05/12/4171831.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705429/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705429/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 13 May 2009 01:23:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/05/12/4171831.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/05/12/4171831.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/05/12/4171831.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705429/1115428http://blog.csdn.net/jinjazz/archive/2009/04/29/4138000.aspxhttp://blog.csdn.net/jinjazz/comments/4138000.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4138000.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4138000SQLServer数据导出到excel有很多种方法，比如dts、ssis、还可以用sql语句调用openrowset。我们这里开拓思路，用CLR来生成Excel文件，并且会考虑一些方便操作的细节。<img src ="http://blog.csdn.net/jinjazz/aggbug/4138000.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705430/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705430/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 30 Apr 2009 06:06:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/29/4138000.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/29/4138000.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/29/4138000.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705430/1115428http://blog.csdn.net/jinjazz/archive/2009/04/28/4133838.aspxhttp://blog.csdn.net/jinjazz/comments/4133838.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4133838.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4133838树结构广泛用在各类分级管理设计中。但他的展现方式也是很让人头疼的事情。比如展开一个靠id和parentid建立关系的分级树...<img src ="http://blog.csdn.net/jinjazz/aggbug/4133838.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705431/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705431/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 29 Apr 2009 03:17:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/28/4133838.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/28/4133838.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/28/4133838.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705431/1115428http://blog.csdn.net/jinjazz/archive/2009/04/28/4132162.aspxhttp://blog.csdn.net/jinjazz/comments/4132162.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4132162.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4132162环比就是本月和上月的差值所占上月值的比例。在复杂的olap计算中我们经常会用到同比环比等概念，要求的上个维度的某个字段的实现语句非常简练，比如 ssas的mdx语句类似[维度].CurrentMember.Prevmember就可以了。此类问题还可以延伸到类似进销存的批次计算中，这也要关注其他历史记录来决定当前某条记录的状态。<img src ="http://blog.csdn.net/jinjazz/aggbug/4132162.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705432/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705432/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 28 Apr 2009 19:35:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/28/4132162.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/28/4132162.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/28/4132162.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705432/1115428http://blog.csdn.net/jinjazz/archive/2009/04/23/4102001.aspxhttp://blog.csdn.net/jinjazz/comments/4102001.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4102001.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4102001一颗参天大树居然折在小菜鸟手中，造化弄人<img src ="http://blog.csdn.net/jinjazz/aggbug/4102001.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705433/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705433/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 23 Apr 2009 09:44:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/23/4102001.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/23/4102001.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/23/4102001.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705433/1115428http://blog.csdn.net/jinjazz/archive/2009/04/23/4101974.aspxhttp://blog.csdn.net/jinjazz/comments/4101974.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4101974.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4101974sql语句的字符串函数远远没有开发语言的强大，我们可以通过clr来扩展。<img src ="http://blog.csdn.net/jinjazz/aggbug/4101974.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705434/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705434/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 23 Apr 2009 08:33:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/23/4101974.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/23/4101974.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/23/4101974.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705434/1115428http://blog.csdn.net/jinjazz/archive/2009/04/22/4101746.aspxhttp://blog.csdn.net/jinjazz/comments/4101746.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4101746.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4101746用过Oracle的人都知道Oracle有四个正则表达函数REGEXP_LIKE、REGEXP_INSTR、REGEXP_SUBSTR、和EGEXP_REPLACE，而SQLServer却无法完全实现上面的功能。以前我们知道用sp_OAxxx系列函数来调用js组建实现正则，现在我们可以通过CLR扩展来借助.Net实现。<img src ="http://blog.csdn.net/jinjazz/aggbug/4101746.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705435/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705435/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 23 Apr 2009 06:01:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/22/4101746.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/22/4101746.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/22/4101746.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705435/1115428http://blog.csdn.net/jinjazz/archive/2009/04/20/4096008.aspxhttp://blog.csdn.net/jinjazz/comments/4096008.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4096008.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4096008同行的是.Net大版高歌...<img src ="http://blog.csdn.net/jinjazz/aggbug/4096008.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705436/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705436/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 21 Apr 2009 07:15:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/20/4096008.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/20/4096008.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/20/4096008.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705436/1115428http://blog.csdn.net/jinjazz/archive/2009/04/16/4084142.aspxhttp://blog.csdn.net/jinjazz/comments/4084142.aspx0http://blog.csdn.net/jinjazz/comments/commentRss/4084142.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=408414275151448行数据随机取10条，8毫秒，够快了吧。<img src ="http://blog.csdn.net/jinjazz/aggbug/4084142.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/jinjazz/223705437/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/jinjazz/223705437/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 16 Apr 2009 22:30:00 +0800贾涛http://blog.csdn.net/jinjazz/archive/2009/04/16/4084142.aspx#Feedbackhttp://blog.csdn.net/jinjazz/archive/2009/04/16/4084142.aspx贾涛http://blog.csdn.net/jinjazz/archive/2009/04/16/4084142.aspxhttp://blog.csdn.net/jinjazz/feed.aspxcsdn.net/jinjazz/~1115432/223705437/1115428