SAP ASE includes additional features of Transact-SQL.
- The following extensions to SQL search conditions:
- modulo operator (%)
- negative comparison operators (!>
- !<, and !=)
- bitwise operators (–, ^
- |, and &)
- join operators (*= and =*)
- wildcard characters ([ ] and -)
- not operator (^)
- Fewer restrictions on the group by clause and the order by
clause.
- Subqueries, which can be used almost anywhere an expression is allowed.
- Temporary tables and other temporary database objects, which exist only for the duration of the
current work session.
- User-defined datatypes built on SAP ASE-supplied datatypes.
- The ability to insert data from a table into that same table.
- The ability to extract data from one table and put it into another with the
update command.
- The ability to remove data based on data in other tables using the join in a
delete statement.
- A fast way to delete all rows in a specified table and reclaim the space they took up with the
truncate
table command.
- Identity columns, which provide system-generated values that uniquely identify each row within a
table.
- Updates and selections through views. Unlike most other versions of SQL, Transact-SQL places no
restrictions on retrieving data through views, and few restrictions on updating data
through views.
- Dozens of built-in functions.
- Options to the create index command for fine-tuning aspects of performance
determined by indexes, and controlling the treatment of duplicate keys and rows.
- Control over what happens when a user attempts to enter duplicate keys in a unique index, or
duplicate rows in a table.
- Bitwise operators for use with integer and bit type
columns.
- Support for text and image datatypes.
- The ability to gain access to both SAP and non-SAP databases. With Component Integration
Services, you can access remote tables as if they were local, perform joins, transfer data
between tables, maintain referential integrity, provide applications such as PowerBuilder®
with transparent access to heterogeneous data, and use native remote server capabilities.
For more information, see the Component Integration Services Users
Guide.