Thu, 04 Nov 2010 09:03:00 GMTNo one can go back and make a brand new start.http://blog.csdn.net/blogrss.aspx?username=happyflystonehttp://blog.csdn.net/happyflystone/archive/2010/11/04/5987769.aspx乍一看，大家一定认为这有什么好写的呀，不就是group by [item]嘛，对指定列进行分组而已。我在这里说的是一个将被MS删除、不符合ISO语法的用法（大家可以在MS没有删除前显摆显摆嘛，至少2008没有删除）。好，那这是什么语法呢，那就是Group by ALL 。那它和不加ALL有什么差别呢？ 差别就是加了ALL后包含所有组和结果集，甚至包含那些其中任何行都不满足 WHERE 子句指定的搜索条件的组和结果集。注意的是指定了 ALL，将对组中不满足搜索条件的汇总列返回空值。<img src="http://www1.feedsky.com/t1/432348552/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2010/11/04/5987769.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348552/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348552/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 04 Nov 2010 17:03:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2010/11/04/5987769.aspxdesshttp://blog.csdn.net/happyflystone/archive/2010/11/04/5987769.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348552/1046843http://blog.csdn.net/happyflystone/archive/2010/11/04/5987754.aspx在SQL的连接操作及搜索数据时使用聚合函数时，我们要注意三值逻辑的微妙之处，处理好三值逻辑还得提到一个关键点NULL值。在SQL中UNKNOWN值一般和NULL有关，也就是UNKNOWN值一般出现在包含在有NULL参与的表式中，在这儿大家一定要分清UNKNOWN作为表达式的值与NULL不是一个意思，不要混淆概念。<img src="http://www1.feedsky.com/t1/432348100/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2010/11/04/5987754.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348100/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348100/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 04 Nov 2010 17:00:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2010/11/04/5987754.aspxdesshttp://blog.csdn.net/happyflystone/archive/2010/11/04/5987754.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348100/1046843http://blog.csdn.net/happyflystone/archive/2010/04/01/5442014.aspx取得指定excel文件内的sheet数及每一个sheet的列数----------------------------------------------------------- happyflystone-- 2010.04-- 转载注明出处--->http://blog.csdn.net/happyflystone-- 取得指定excel文件内的sheet数及每一个sheet的列数。------------------------------------------------------CREATEPROC sp_operate_excel@excelfilename NVARCHAR(100),@strErrorMessage VARCHAR(1000) OUTASBEGIN    SETNOCOUNTON    DECLARE @hr IN<img src="http://www1.feedsky.com/t1/432348101/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2010/04/01/5442014.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348101/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348101/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 01 Apr 2010 16:22:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2010/04/01/5442014.aspxdesshttp://blog.csdn.net/happyflystone/archive/2010/04/01/5442014.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348101/1046843http://blog.csdn.net/happyflystone/archive/2010/03/12/5373898.aspx原文地址：http://www.cnblogs.com/zhengyun_ustc/archive/2006/06/29/sqlxml_forxmlexplicit.html[SQLXML]FOR XML语法导出XML的易错之处<br />Version<br />Date<br />Creator<br />Description<br />1.0.0.1<br />2006-6-29<br />郑昀@Ultrapower<br />草稿<br /><br />继续阅读之前，我们假设您熟悉以下知识：<br />n         MS SQL Server 2000<br />n         Sp_makewebtask<br />n         FOR XML 子句<br />如果不熟悉这些知识点，可以看下面两小节[准备工作一：FOR XML]和[准备工作二：sp_makewebtask]；否则可以直接跳过。[准备工作一：FOR XML]<br />关键词：      FOR XML AUTO/EXPLICIT。<br />功能：          可以对现有的关系数据库<img src="http://www1.feedsky.com/t1/432348102/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2010/03/12/5373898.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348102/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348102/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 12 Mar 2010 14:17:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2010/03/12/5373898.aspxdesshttp://blog.csdn.net/happyflystone/archive/2010/03/12/5373898.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348102/1046843http://blog.csdn.net/happyflystone/archive/2010/01/20/5216689.aspxSQL2005中的事务与锁定（九） (二) ------------------------------------------------------------------------ -- Author : HappyFlyStone -- Date : 2010-01-18 22：00 -- Version: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) -- Apr 14 2006 01:12:25 -- Copyright (c) 1988-2005 Microsoft Corporation -- Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) -- 转载请注明出处，更多请关注：http://blog.csdn.net/happyflystone -- 关键字：行版本存储二、tempdb --------------------------<img src="http://www1.feedsky.com/t1/432348103/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2010/01/20/5216689.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348103/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348103/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 20 Jan 2010 13:12:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2010/01/20/5216689.aspxdesshttp://blog.csdn.net/happyflystone/archive/2010/01/20/5216689.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348103/1046843http://blog.csdn.net/happyflystone/archive/2009/12/09/4969909.aspx行(和我平常说的表的记录行有点差别哦，注意理解)简单的可理解为数据库物理存储的表、索引及其它类型的数据的基本单元。当然行结构远不止如下说明的那么简单，更深入的有待再度剖析，比如打开行版本后slot记录就会多出14个字节的xsn。<img src="http://www1.feedsky.com/t1/432348104/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2009/12/09/4969909.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348104/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348104/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 09 Dec 2009 10:40:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2009/12/09/4969909.aspxdesshttp://blog.csdn.net/happyflystone/archive/2009/12/09/4969909.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348104/1046843http://blog.csdn.net/happyflystone/archive/2009/12/02/4923803.aspx本篇介绍一下当我们通过alter table来修改数据表的列类型时因SQLSERVER只检查不修改数据而造成让大家迷惑的假象，或说是让人费解的地方。在这里我们只介绍三种情况：一增加列(有无缺省)；二，删除列；三修改列；在大多数的情况下，SQLSERVER只要修改元数据而可能不会去触碰页面上的物理数据，所以如果我们通过dbcc page来查看页面的内容时会有点让人晕头转向，下面们先简单的说三种情况，最后做一些的解释。<img src="http://www1.feedsky.com/t1/432348105/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2009/12/02/4923803.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348105/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348105/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 02 Dec 2009 13:29:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2009/12/02/4923803.aspxdesshttp://blog.csdn.net/happyflystone/archive/2009/12/02/4923803.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348105/1046843http://blog.csdn.net/happyflystone/archive/2009/11/19/4834762.aspxSQL2005中的事务与锁定（九）(一)-------------------------------------------------------------------------- Author : HappyFlyStone -- Date   : 2009-11-09-- Version: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) --      Apr 14 2006 01:12:25 --      Copyright (c) 1988-2005 Microsoft Corporation--      Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)--       转载请注明出处，更多请关注：http://blog.csdn.net/happyflystone--       关<img src="http://www1.feedsky.com/t1/432348106/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2009/11/19/4834762.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348106/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348106/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 19 Nov 2009 13:57:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2009/11/19/4834762.aspxdesshttp://blog.csdn.net/happyflystone/archive/2009/11/19/4834762.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348106/1046843http://blog.csdn.net/happyflystone/archive/2009/11/15/4813425.aspx转：经典Excel VBA代码<img src="http://www1.feedsky.com/t1/432348107/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2009/11/15/4813425.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348107/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348107/art01.gif" onerror="this.style.display='none'" /></a></p>Sun, 15 Nov 2009 19:02:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2009/11/15/4813425.aspxdesshttp://blog.csdn.net/happyflystone/archive/2009/11/15/4813425.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348107/1046843http://blog.csdn.net/happyflystone/archive/2009/11/11/4798786.aspxSQL2000下非sysadmin固定服务器角色的成员执行xp_cmdshell<img src="http://www1.feedsky.com/t1/432348108/happyflystone/csdn.net/s.gif?r=http://blog.csdn.net/happyflystone/archive/2009/11/11/4798786.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/happyflystone/432348108/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/happyflystone/432348108/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 11 Nov 2009 16:07:00 +0800desshttp://blog.csdn.net/happyflystone/archive/2009/11/11/4798786.aspxdesshttp://blog.csdn.net/happyflystone/archive/2009/11/11/4798786.aspxhttp://blog.csdn.net/happyflystone/feed.aspxcsdn.net/happyflystone/~1046843/432348108/1046843