Application Development Architecture

Applications use two components to access a database:

This section discusses:

Transact-SQL

The database language supported by SQL Server is Transact-SQL. Transact-SQL complies with the Entry Level of the SQL-92 standard, but also supports several features from the Intermediate and Full Levels. It also supports some powerful extensions to the SQL-92 standard. For more information, see Getting Started with Transact-SQL.

The ODBC specification defined extensions to the SQL defined in the SQL-92 standard. These ODBC SQL extensions are also supported by OLE DB. Transact-SQL supports the ODBC extensions from applications using the Microsoft ActiveX® Data Objects (ADO), OLE DB, or ODBC APIs, or the APIs that map over ODBC.

APIs Supported by SQL Server

SQL Server supports a number of APIs for building general-purpose database applications:

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.