Export (0) Print
Expand All

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

SQL Server 2005

New: 17 July 2006

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

Multidimensional Expressions (MDX)

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)

Arrow icon used with Back to Top link Back to Top

Community Additions

ADD
Show:
© 2014 Microsoft