http://blog.csdn.net/happyflystone/心若无尘，一花一世界，一鸟一天堂zh-CNMon, 24 Nov 2008 10:55:00 GMT60无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/11/24/3360712.aspxMon, 24 Nov 2008 10:45:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/11/24/3360712.aspxhttp://blog.csdn.net/happyflystone/comments/3360712.aspxhttp://blog.csdn.net/happyflystone/archive/2008/11/24/3360712.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/3360712.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3360712利用xml改造以前在2000下的合并相同项目的函数<img src ="http://blog.csdn.net/happyflystone/aggbug/3360712.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/11/19/3335795.aspxWed, 19 Nov 2008 17:04:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/11/19/3335795.aspxhttp://blog.csdn.net/happyflystone/comments/3335795.aspxhttp://blog.csdn.net/happyflystone/archive/2008/11/19/3335795.aspx#Feedback2http://blog.csdn.net/happyflystone/comments/commentRss/3335795.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3335795利用xml在指定分隔符的情况下获取指定数据项的指定位置的串<img src ="http://blog.csdn.net/happyflystone/aggbug/3335795.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/11/04/3216965.aspxTue, 04 Nov 2008 11:06:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/11/04/3216965.aspxhttp://blog.csdn.net/happyflystone/comments/3216965.aspxhttp://blog.csdn.net/happyflystone/archive/2008/11/04/3216965.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/3216965.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3216965[正则表达式]非常经典的正则表达式 mark<img src ="http://blog.csdn.net/happyflystone/aggbug/3216965.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/11/04/3216926.aspxTue, 04 Nov 2008 11:04:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/11/04/3216926.aspxhttp://blog.csdn.net/happyflystone/comments/3216926.aspxhttp://blog.csdn.net/happyflystone/archive/2008/11/04/3216926.aspx#Feedback1http://blog.csdn.net/happyflystone/comments/commentRss/3216926.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3216926利用typeperf工具收集SQL Server性能数据--------MARK<img src ="http://blog.csdn.net/happyflystone/aggbug/3216926.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/11/02/3207725.aspxSun, 02 Nov 2008 22:09:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/11/02/3207725.aspxhttp://blog.csdn.net/happyflystone/comments/3207725.aspxhttp://blog.csdn.net/happyflystone/archive/2008/11/02/3207725.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/3207725.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3207725转过来的，有时间研究一下<img src ="http://blog.csdn.net/happyflystone/aggbug/3207725.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/10/26/3150190.aspxSun, 26 Oct 2008 16:08:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/10/26/3150190.aspxhttp://blog.csdn.net/happyflystone/comments/3150190.aspxhttp://blog.csdn.net/happyflystone/archive/2008/10/26/3150190.aspx#Feedback1http://blog.csdn.net/happyflystone/comments/commentRss/3150190.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3150190测试文章效果<img src ="http://blog.csdn.net/happyflystone/aggbug/3150190.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/10/25/3139424.aspxSat, 25 Oct 2008 00:56:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/10/25/3139424.aspxhttp://blog.csdn.net/happyflystone/comments/3139424.aspxhttp://blog.csdn.net/happyflystone/archive/2008/10/25/3139424.aspx#Feedback1http://blog.csdn.net/happyflystone/comments/commentRss/3139424.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3139424 今天打开CSDN发一个网友问我如何用T-SQL判断某个表在ACCESS中是否存在，也就是如何用t-sql显示access的用户表，其实access有一个隐藏了类似于sysobjects的系统表，并且必须设置权限才可以访问得到<img src ="http://blog.csdn.net/happyflystone/aggbug/3139424.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/10/19/3102372.aspxSun, 19 Oct 2008 14:49:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/10/19/3102372.aspxhttp://blog.csdn.net/happyflystone/comments/3102372.aspxhttp://blog.csdn.net/happyflystone/archive/2008/10/19/3102372.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/3102372.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3102372常见问题 - SQL Server 2000 - 安装<img src ="http://blog.csdn.net/happyflystone/aggbug/3102372.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/10/05/3017655.aspxSun, 05 Oct 2008 15:14:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/10/05/3017655.aspxhttp://blog.csdn.net/happyflystone/comments/3017655.aspxhttp://blog.csdn.net/happyflystone/archive/2008/10/05/3017655.aspx#Feedback3http://blog.csdn.net/happyflystone/comments/commentRss/3017655.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3017655[学习SQL SERVER 2005系列]关于INSERT、UPDATE 或 DELETE的OUTPUT及OUTPUT...INTO...用法　　　　　作者：Flystone ,转载注明出处<img src ="http://blog.csdn.net/happyflystone/aggbug/3017655.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/09/22/2962130.aspxMon, 22 Sep 2008 15:33:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/09/22/2962130.aspxhttp://blog.csdn.net/happyflystone/comments/2962130.aspxhttp://blog.csdn.net/happyflystone/archive/2008/09/22/2962130.aspx#Feedback1http://blog.csdn.net/happyflystone/comments/commentRss/2962130.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2962130 今晚我们就看看SQL2005这个UNPIVOT吧。UNPIVOT几乎完全是PIVOT相反的操作，将列转换为行。它和PIVOT 关系运算符一样对表值表达式进行操作以获得另一个表。记得我们在SQL2000中要用UNION ALL 来把多列合并到一列的情况吧，同样对于列不定时，我们往往还利用系统表syscolumns来构造动态SQL，然后用EXEC来运行。<img src ="http://blog.csdn.net/happyflystone/aggbug/2962130.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/09/18/2947941.aspxThu, 18 Sep 2008 16:44:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/09/18/2947941.aspxhttp://blog.csdn.net/happyflystone/comments/2947941.aspxhttp://blog.csdn.net/happyflystone/archive/2008/09/18/2947941.aspx#Feedback1http://blog.csdn.net/happyflystone/comments/commentRss/2947941.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2947941MCITP Self-Paced Training Kit (Exam 70-238): Deploying Messaging Solutions with Microsoft? Exchange Server 2007读后感<img src ="http://blog.csdn.net/happyflystone/aggbug/2947941.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/09/18/2946330.aspxThu, 18 Sep 2008 12:38:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/09/18/2946330.aspxhttp://blog.csdn.net/happyflystone/comments/2946330.aspxhttp://blog.csdn.net/happyflystone/archive/2008/09/18/2946330.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/2946330.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2946330 工具的升级，我以为得先看看这个工具在哪些功能上得到加强，今天我们就看看SQL2005这个PIVOT吧。PIVOT 关系运算符对表值表达式进行操作以获得另一个表。PIVOT 通过将表达式某一列中的唯一值转换为输出中的多个列来转换表值表达式，并在必要时对最终输出中所需的任何其余的列值执行聚合。记得我们在SQL2000中要用聚合和CASE语句完成一个行列转换吧，特别当待转成列的数据不定时，我们往往构造动态SQL，然后用EXEC来运行。 <img src ="http://blog.csdn.net/happyflystone/aggbug/2946330.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/09/15/2934050.aspxMon, 15 Sep 2008 20:44:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/09/15/2934050.aspxhttp://blog.csdn.net/happyflystone/comments/2934050.aspxhttp://blog.csdn.net/happyflystone/archive/2008/09/15/2934050.aspx#Feedback5http://blog.csdn.net/happyflystone/comments/commentRss/2934050.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2934050[学习SQL SERVER 2005系列]图解SQL SERVER2005的安装Word文档在我的资源中，欢迎下载。<img src ="http://blog.csdn.net/happyflystone/aggbug/2934050.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/09/13/2923951.aspxSat, 13 Sep 2008 18:17:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/09/13/2923951.aspxhttp://blog.csdn.net/happyflystone/comments/2923951.aspxhttp://blog.csdn.net/happyflystone/archive/2008/09/13/2923951.aspx#Feedback0http://blog.csdn.net/happyflystone/comments/commentRss/2923951.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2923951Excel的数据导入到PB的DW中<img src ="http://blog.csdn.net/happyflystone/aggbug/2923951.aspx" width = "1" height = "1" />无枪狙击手http://blog.csdn.net/happyflystone/archive/2008/08/06/2777320.aspxWed, 06 Aug 2008 16:07:00 GMThttp://blog.csdn.net/happyflystone/archive/2008/08/06/2777320.aspxhttp://blog.csdn.net/happyflystone/comments/2777320.aspxhttp://blog.csdn.net/happyflystone/archive/2008/08/06/2777320.aspx#Feedback2http://blog.csdn.net/happyflystone/comments/commentRss/2777320.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2777320Log explorer 对drop/truncate table的数据恢复<img src ="http://blog.csdn.net/happyflystone/aggbug/2777320.aspx" width = "1" height = "1" />