Language Reference: New and Updated Topics (17 July 2006)

New: 17 July 2006

In the 17 July 2006 release of SQL Server Books Online, the following topics have either been added or updated.

Topic Categories

Updated Conceptual and Task Topics

New Reference Topics

Updated Reference Topics

Updated Conceptual and Task Topics

Multidimensional Expressions (MDX)

Key Concepts in MDX (MDX)

MDX Function Reference (MDX)

Transact-SQL

Ranking Functions (Transact-SQL)

Reserved Keywords (Transact-SQL)

Back to Top

New Reference Topics

Multidimensional Expressions (MDX)

CurrentOrdinal (MDX)

Back to Top

Updated Reference Topics

Multidimensional Expressions (MDX)

AddCalculatedMembers (MDX)

Aggregate (MDX)

AllMembers (MDX)

Ancestor (MDX)

Ancestors (MDX)

Ascendants (MDX)

Avg (MDX)

Axis (MDX)

BottomCount (MDX)

BottomPercent (MDX)

BottomSum (MDX)

CALCULATE Statement (MDX)

CalculationCurrentPass (MDX)

CalculationPassValue (MDX)

Children (MDX)

ClosingPeriod (MDX)

CoalesceEmpty (MDX)

Correlation (MDX)

Count (Dimension) (MDX)

Count (Hierarchy Levels) (MDX)

Count (Set) (MDX)

Count (Tuple) (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 (Member) (MDX)

Item (Tuple) (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 (Set) (MDX)

Members (String) (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 and 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 and 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)

Join Hint (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 Clause (Transact-SQL)

Query Hint (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)

Back to Top