Référence du langage : Nouvelles rubriques et rubriques mises à jour (17 juillet 2006)

Nouveau : 17 juillet 2006

Dans la version 17 juillet 2006 de la documentation en ligne SQL Server, les rubriques suivantes ont été ajoutées ou mises à jour.

Catégories de rubrique

Rubriques conceptuelles et consacrées aux tâches mises à jour

Nouvelles rubriques de référence

Rubriques de référence mises à jour

Rubriques conceptuelles et consacrées aux tâches mises à jour

Expressions multidimensionnelles (MDX, Multidimensional Expressions)

Concepts clés dans MDX (MDX)

Guide de référence des fonctions MDX (MDX)

Transact-SQL

Fonctions de classement (Transact-SQL)

Mots clés réservés (Transact-SQL)

Retour en haut

Nouvelles rubriques de référence

Expressions multidimensionnelles (MDX, Multidimensional Expressions)

CurrentOrdinal (MDX)

Retour en haut

Rubriques de référence mises à jour

MDX (Multidimensional Expressions - Expressions multidimensionnelles)

AddCalculatedMembers (MDX)

Aggregate (MDX)

AllMembers (MDX)

Ancestor (MDX)

Ancestors (MDX)

Ascendants (MDX)

Avg (MDX)

Axis (MDX)

BottomCount (MDX)

BottomPercent (MDX)

BottomSum (MDX)

Instruction CALCULATE (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 et 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 et 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)

Indicateur de jointure (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)

Clause OVER (Transact-SQL)

Indicateur de requête (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)

MSdbms (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)

Retour en haut