语言参考:新的和已更新的主题(2006 年 7 月 17 日)

新建日期: 2006 年 7 月 17 日

在 SQL Server 联机丛书的 2006 年 7 月 17 日 版本中,添加或更新了以下主题。

主题类别

更新的概念性和任务主题

新的参考主题

更新的参考主题

更新的概念性和任务主题

多维表达式 (MDX)

MDX 中的重要概念 (MDX)

MDX 函数参考 (MDX)

Transact-SQL

排名函数 (Transact-SQL)

保留关键字 (Transact-SQL)

用于“返回首页”链接的箭头图标返回页首

新的参考主题

多维表达式 (MDX)

CurrentOrdinal (MDX)

用于“返回首页”链接的箭头图标返回页首

更新的参考主题

多维表达式 (MDX)

AddCalculatedMembers (MDX)

Aggregate (MDX)

AllMembers (MDX)

Ancestor (MDX)

Ancestors (MDX)

Ascendants (MDX)

Avg (MDX)

Axis (MDX)

BottomCount (MDX)

BottomPercent (MDX)

BottomSum (MDX)

CALCULATE 语句 (MDX)

CalculationCurrentPass (MDX)

CalculationPassValue (MDX)

Children (MDX)

ClosingPeriod (MDX)

CoalesceEmpty (MDX)

Correlation (MDX)

Count(维度)(MDX)

Count(层次结构级别)(MDX)

Count(集)(MDX)

Count(元组)(MDX)

Cousin (MDX)

Covariance (MDX)

CovarianceN (MDX)

Crossjoin (MDX)

Current (MDX)

CurrentMember (MDX)

CustomData (MDX)

DataMember (MDX)

DefaultMember (MDX)

Descendants (MDX)

Dimension (MDX)

Dimensions (MDX)

Distinct (MDX)

DistinctCount (MDX)

DrilldownLevel (MDX)

DrilldownLevelBottom (MDX)

DrilldownLevelTop (MDX)

DrilldownMember (MDX)

DrilldownMemberBottom (MDX)

DrilldownMemberTop (MDX)

DrillupLevel (MDX)

DrillupMember (MDX)

Error (MDX)

Except (MDX)

Exists (MDX)

Extract (MDX)

Filter (MDX)

FirstChild (MDX)

FirstSibling (MDX)

Generate (MDX)

Head (MDX)

Hierarchize (MDX)

Hierarchy (MDX)

IIf (MDX)

Intersect (MDX)

IsAncestor (MDX)

IsEmpty (MDX)

IsGeneration (MDX)

IsLeaf (MDX)

IsSibling (MDX)

Item(成员)(MDX)

Item(元组)(MDX)

KPICurrentTimeMember (MDX)

KPIGoal (MDX)

KPIStatus (MDX)

KPITrend (MDX)

KPIValue (MDX)

KPIWeight (MDX)

Lag (MDX)

LastChild (MDX)

LastPeriods (MDX)

LastSibling (MDX)

Lead (MDX)

Leaves (MDX)

Level (MDX)

Levels (MDX)

LinkMember (MDX)

LinRegIntercept (MDX)

LinRegPoint (MDX)

LinRegR2 (MDX)

LinRegSlope (MDX)

LinRegVariance (MDX)

LookupCube (MDX)

Max (MDX)

MeasureGroupMeasures (MDX)

Median (MDX)

Members(集)(MDX)

Members(字符串)(MDX)

MemberToStr (MDX)

MemberValue (MDX)

Min (MDX)

Mtd (MDX)

Name (MDX)

NameToSet (MDX)

NextMember (MDX)

NonEmpty (MDX)

NonEmptyCrossjoin (MDX)

OpeningPeriod (MDX)

Order (MDX)

Ordinal (MDX)

ParallelPeriod (MDX)

Parent (MDX)

PeriodsToDate (MDX)

Predict (MDX)

PrevMember (MDX)

Properties (MDX)

Qtd (MDX)

Rank (MDX)

RollupChildren (MDX)

Root (MDX)

SetToArray (MDX)

SetToStr (MDX)

Siblings (MDX)

Stddev (MDX)

StddevP (MDX)

Stdev (MDX)

StdevP (MDX)

StripCalculatedMembers (MDX)

StrToMember (MDX)

StrToSet (MDX)

StrToTuple (MDX)

StrToValue (MDX)

Subset (MDX)

Sum (MDX)

Tail (MDX)

This (MDX)

ToggleDrillState (MDX)

TopCount (MDX)

TopPercent (MDX)

TopSum (MDX)

TupleToStr (MDX)

Union (MDX)

UniqueName (MDX)

UnknownMember (MDX)

Unorder (MDX)

UserName (MDX)

ValidMeasure (MDX)

Value (MDX)

Var (MDX)

Variance (MDX)

VarianceP (MDX)

VarP (MDX)

VisualTotals (MDX)

Wtd (MDX)

Ytd (MDX)

Transact-SQL

ABS (Transact-SQL)

ADD SIGNATURE (Transact-SQL)

ALL (Transact-SQL)

BULK INSERT (Transact-SQL)

CAST 和 CONVERT (Transact-SQL)

CHECK_CONSTRAINTS (Transact-SQL)

COL_LENGTH (Transact-SQL)

COL_NAME (Transact-SQL)

COLUMNPROPERTY (Transact-SQL)

COLUMNS (Transact-SQL)

CONTAINSTABLE (Transact-SQL)

CREATE LOGIN (Transact-SQL)

CREATE PARTITION FUNCTION (Transact-SQL)

CREATE SCHEMA (Transact-SQL)

CREATE TRIGGER (Transact-SQL)

CREATE VIEW (Transact-SQL)

DATABASEPROPERTY (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DATENAME (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC SHOWCONTIG (Transact-SQL)

DBCC SQLPERF (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP SIGNATURE (Transact-SQL)

EXCEPT 和 INTERSECT (Transact-SQL)

FREETEXTTABLE (Transact-SQL)

FULLTEXTCATALOGPROPERTY (Transact-SQL)

GROUP BY (Transact-SQL)

IDENT_CURRENT (Transact-SQL)

IDENT_INCR (Transact-SQL)

IDENT_SEED (Transact-SQL)

INDEX_COL (Transact-SQL)

INDEXKEY_PROPERTY (Transact-SQL)

INDEXPROPERTY (Transact-SQL)

联接提示 (Transact-SQL)

MSmerge_conflicts_info (Transact-SQL)

NTILE (Transact-SQL)

OBJECT_DEFINITION (Transact-SQL)

OBJECT_ID (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

OPENQUERY (Transact-SQL)

OPENROWSET (Transact-SQL)

OVER 子句 (Transact-SQL)

查询提示 (Transact-SQL)

RAISERROR (Transact-SQL)

ROW_NUMBER (Transact-SQL)

SET FMTONLY (Transact-SQL)

SET OFFSETS (Transact-SQL)

SET QUERY_GOVERNOR_COST_LIMIT (Transact-SQL)

SOME | ANY (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_columns (Transact-SQL)

sp_columns_ex (Transact-SQL)

sp_dbcmptlevel (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_fulltext_database (Transact-SQL)

sp_help (Transact-SQL)

sp_help_log_shipping_monitor (Transact-SQL)

sp_notify_operator (Transact-SQL)

sp_setapprole (Transact-SQL)

sp_statistics (Transact-SQL)

sp_stored_procedures (Transact-SQL)

STATS_DATE (Transact-SQL)

sys.check_constraints (Transact-SQL)

sys.computed_columns (Transact-SQL)

sys.default_constraints (Transact-SQL)

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_db_missing_index_group_stats

sys.dm_db_missing_index_groups

sys.dm_io_virtual_file_stats

sys.dm_os_child_instances

sys.dm_os_hosts

sys.dm_os_latch_stats

sys.login_token (Transact-SQL)

sys.servers (Transact-SQL)

sys.syscomments (Transact-SQL)

TYPE_ID (Transact-SQL)

TYPE_NAME (Transact-SQL)

TYPEPROPERTY (Transact-SQL)

用于“返回首页”链接的箭头图标返回页首