Users do not access SOL Server and Analysis Services directly; instead, they use separate client applications written to access the data. These applications access SOL Server by using:

Transact-SQL
This quer'y language, a version of Structured Ouery Language (SOL), is the primary database query and programming language that SOL Server uses.

XML
This format returns data from queries and stored procedures by using URLs or templates over Hypertext Transfer Protocol (HTIP). You also can use XML to insert, delete, and update values in a database.

Name: SQL Client Application.jpg Views: 72 Size: 44.3 KB

MDX
The MDX syntax defines multidimensional objects and queries and manipulates multidimensional data in OLAP databases.

OLE DB and DOBC APls
Client applications use OLE DB and Open Database Connectivity (ODBC), application programming interfaces (APls) to send commands to a database. Commands•that you send through these APls