<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Megan2008的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/megan2008</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; megan2008]]></copyright><item><title><![CDATA[Microsoft SQL Server MDX step by step 第六章]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/82997706</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/82997706</guid><author>megan2008</author><pubDate>Wed, 10 Oct 2018 15:31:05 +0800</pubDate><description><![CDATA[书中关于Item的讲解有点不好理解，通过查询一些文档，这里对它进行进一步说明。

这个函数是用于返回集合中的某一元组，当已经定位到元组的时候，可以返回元组中的某一成员。

{Set} | (Tuple.Item(i)   这里的i从0开始

{Set}.Item(String1 [,String2,..., Stringn])

举个例子：


SELECT {} on columns ,
 { ...]]></description><category></category></item><item><title><![CDATA[Microsoft SQL Server MDX step by step 第五章]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/82909975</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/82909975</guid><author>megan2008</author><pubDate>Sun, 30 Sep 2018 15:24:01 +0800</pubDate><description><![CDATA[Properties 用于返回成员的属性， member.Properties( Name [, TYPED] )    

一般情况下是以字符串的形式返回。如果我们使用Typed关键字，那么将按照这个属性本身的数据类型来返回。下面两个语句的执行结果相同

指定typed 关键字，返回是Level_Number本身的数值类型
			未指定typed 关键字，返回类型是字符串
		WITH
			M...]]></description><category></category></item><item><title><![CDATA[BI books]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/8435258</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/8435258</guid><author>megan2008</author><pubDate>Tue, 25 Dec 2012 21:34:56 +0800</pubDate><description><![CDATA[If you’re just getting started and want a holistic overview of the Kimball approach, start with the
Lifecycle Toolkit. The Data Warehouse Toolkit covers dimensional modeling in detail, while the
ETL]]></description><category></category></item><item><title><![CDATA[Internals viewer-- a plugin for SSMS]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/8315605</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/8315605</guid><author>megan2008</author><pubDate>Tue, 18 Dec 2012 18:01:31 +0800</pubDate><description><![CDATA[如果安装的SQL SERVER 版本不同，需要安装不同的internals viewer
 
SQL SERVER plugin : Internals viewer for SQL SERVER 2008 R2
http://intview2.codeplex.com/
 
Internals viewer user guide
http://internalsviewer.code]]></description><category></category></item><item><title><![CDATA[SQL SERVER Protocals]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/8269651</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/8269651</guid><author>megan2008</author><pubDate>Fri, 07 Dec 2012 15:27:59 +0800</pubDate><description><![CDATA[Shared Memory The simplest protocol to use, with no configurable settings. Clients using the Shared Memory protocol can connect only to a SQL Server instance running on the same computer, so this prot]]></description><category></category></item><item><title><![CDATA[SSAS 中查询Dimension表中的所有值]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/8240415</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/8240415</guid><author>megan2008</author><pubDate>Thu, 29 Nov 2012 17:35:44 +0800</pubDate><description><![CDATA[SELECT

{} ON
COLUMNS,

[Product].[Rt Prod Brand].
children
ON
ROWS

FROM

sales]]></description><category></category></item><item><title><![CDATA[SQL SERVER]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/8215902</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/8215902</guid><author>megan2008</author><pubDate>Fri, 23 Nov 2012 11:33:46 +0800</pubDate><description><![CDATA[An Introduction to Clustered and Non-Clustered Index Data Structures
http://www.sql-server-performance.com/2004/index-data-structures/
 如何看懂执行计划
http://www.blogjava.net/jiabao/archive/2008/04/08/19]]></description><category></category></item><item><title><![CDATA[oracle IZ0-042考试题库解析]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/6291717</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/6291717</guid><author>megan2008</author><pubDate>Thu, 31 Mar 2011 14:58:00 +0800</pubDate><description><![CDATA[写给自己学习用,也可以让我需要的朋友参考4. Which three statements are true about the stages of database startup? (Choose three.)A) Data files and redo]]></description><category></category></item><item><title><![CDATA[linux 文件系统几个常用目录的作用]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/6195542</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/6195542</guid><author>megan2008</author><pubDate>Sat, 19 Feb 2011 22:12:00 +0800</pubDate><description><![CDATA[<br /> <br />Linux根目录”/“下各个系统文件夹的含义和用途<br /> <br />/var 文档目录<br /> <br />/usr 应用程序目录]]></description><category></category></item><item><title><![CDATA[sql*loader 用法1]]></title><link>https://blog.youkuaiyun.com/megan2008/article/details/6182260</link><guid>https://blog.youkuaiyun.com/megan2008/article/details/6182260</guid><author>megan2008</author><pubDate>Sun, 13 Feb 2011 13:22:00 +0800</pubDate><description><![CDATA[sql*loader control file 写法使用的例子均是oracle自带的例子，路径为：rdbms/demo ，以ulcase开头的文件共11个，介绍sql*load用法写出来纯粹是供自己学习使用1 数据文件在控制文件中  LOAD DATA   INFILE *   [INSERT|APPEND|REPLACE|TRUNCATE] INTO TABLE dept  --------注释1  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"', ]]></description><category></category></item></channel></rss>