Transact-SQL Procedure Language Overview

The stored procedure language is the part of SQL used in stored procedures and batches.

SQL Anywhere and Sybase IQ support a large part of the Transact-SQL stored procedure language in addition to the Watcom-SQL dialect based on SQL92.

• Transact-SQL Stored Procedure Overview
  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.
• Transact-SQL Batch Overview
  In Transact-SQL, a batch is a set of SQL statements submitted together and executed as a group, one after the other.
• SQL Statements in Procedures and Batches
  Some SQL statements supported by Sybase IQ are part of one dialect, but not the other.