SQL Server Language Reference

The following table lists the languages included with Microsoft SQL Server 2005.

Language Description


Transact-SQL is the language used to administer instances of the SQL Server Database Engine, to create and manage database objects, and to insert, retrieve, modify, and delete data. Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI).

Multidimensional Expressions (MDX)

Multidimensional Expressions (MDX) is a statement-based scripting language used to define, manipulate, and retrieve data from multidimensional objects in SQL Server 2005 Analysis Services (SSAS). MDX provides data definition language (DDL) statements; data manipulation language (DML) statements; scripting language statements for managing scope, context, and control of flow within MDX scripts; operators and functions for the manipulation of data retrieved from multidimensional objects; and the capability to extend MDX with user-defined functions.

Data Mining Extensions (DMX)

Data Mining Extensions (DMX) is the language used to create and work with data mining models in SSAS. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.