ASA SQL User's Guide
  Transact-SQL Compatibility
    Transact-SQL procedure language overview

Transact-SQL stored procedure overview

Based on the ISO/ANSI draft standard , the Adaptive Server Anywhere stored procedure language differs from the Transact-SQL dialect in many ways. Many of the concepts and features are similar, but the syntax is different. Adaptive Server Anywhere support for Transact-SQL takes advantage of the similar concepts by providing automatic translation between dialects. However, a procedure must be written exclusively in one of the two dialects, not in a mixture of the two.

Adaptive Server Anywhere support for Transact-SQL stored procedures 

There are a variety of aspects to Adaptive Server Anywhere support for Transact-SQL stored procedures, including:

• Passing parameters

• Returning result sets

• Returning status information

• Providing default values for parameters

• Control statements

• Error handling

• User-defined functions