Category: ASE: T-SQL

Transact-SQL, T-SQL

Transact-SQL or short T-SQL is a computer language developed by Sybase® based on SQL. It is used to create, manipulate and controle ASE (Adaptive Server® Enterprise). T-SQL is not compatible to the ANSI standard. This means that T-SQL can be executed on ASE but not on all other database systems.

T-SQL is based on the four independent language layers of SQL and contains the complete set of SQL standard commands:

• Data Definition Language (DDL) - for defining a database schema.
• Data Query Language (DQL) - for data retrieval.
• Data Manipulation Language (DML) - for modifying a data set.
• Data Control Language (DCL) - for controlling database resources.

T-SQL Extensions

The extensions of T-SQL are required to handle all aspects of the server and database management of an Adaptive Servers®. The T-SQL extensions compared to ANSI SQL standard are in detail:

• variables
• User Control Messages
• Flow Control Statements
• Index Support: clustered and nonclustered
• Rules and Default Objects
• User Definded Datatypes
• DML Extension
• Session Management Options

If pure ANSI-compatible SQL is required, it is recommended to switch on the FIPS flagger, which will issue warnings if T-SQL commands are used.

See also:

has_role(),
Logical Operators.