Contents Index Accessing the Plan with SQL functions An overview of Transact-SQL support

ASA SQL User's Guide

Transact-SQL Compatibility


About this chapter 

Transact-SQL is the dialect of SQL supported by Sybase Adaptive Server Enterprise.

This chapter is a guide for creating applications that are compatible with both Adaptive Server Anywhere and Adaptive Server Enterprise. It describes Adaptive Server Anywhere support for Transact-SQL language elements and statements, and for Adaptive Server Enterprise system tables, views, and procedures.


An overview of Transact-SQL support
Adaptive Server architectures
Configuring databases for Transact-SQL compatibility
Writing compatible SQL statements
Transact-SQL procedure language overview
Automatic translation of stored procedures
Returning result sets from Transact-SQL procedures
Variables in Transact-SQL procedures
Error handling in Transact-SQL procedures

Contents Index Accessing the Plan with SQL functions An overview of Transact-SQL support