Because it is based on the ISO/ANSI draft standard, the SQL Anywhere and Sybase IQ 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. SQL Anywhere and Sybase IQ support for Transact-SQL takes advantage of the similar concepts by providing automatic translation between dialects. However, you must write a procedure exclusively in one of the two dialects, not in a mixture of the two.
There are a variety of aspects to SQL Anywhere and Sybase IQ support for Transact-SQL stored procedures, including:
Passing parameters
Returning result sets
Returning status information
Providing default values for parameters
Control statements
Error handling
