Export (0) Print
Expand All
24 out of 105 rated this helpful - Rate this topic

SQL Server Language Reference

SQL Server 2005

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

Language Description

Transact-SQL

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.