Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Transact-SQL procedure language overview


Transact-SQL stored procedure overview

The native SQL Anywhere dialect, Watcom-SQL, is based on the ISO/ANSI SQL/2008 standard. Consequently, the Watcom-SQL stored procedure dialect 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 dialects. However, a procedure must be written exclusively in one of the two dialects, not in a mixture of the two.

 SQL Anywhere support for Transact-SQL stored procedures