User's Guide

Part IV. Transact-SQL Compatibility

Chapter 31. Transact-SQL Procedure Language

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

SQL Anywhere support for Transact-SQL stored procedures

SQL Anywhere support for the following Transact-SQL stored procedure elements is discussed in this chapter:

• Passing parameters
• Returning result sets
• Returning status information
• Providing default values for parameters
• Control statements
• Error handling