User's Guide
PART 5. The Adaptive Server Family
Transact-SQL is the dialect of SQL supported by Sybase Adaptive Server Enterprise.
This chapter is a guide for creating applications that are compatible with both Adaptive Server Anywhere and Adaptive Server Enterprise. It describes Adaptive Server Anywhere support for Transact-SQL language elements and statements, and for Adaptive Server Enterprise system tables, views, and procedures.
For brevity, in this chapter, Adaptive Server Enterprise is occasionally abbreviated to Enterprise, and Adaptive Server Anywhere is occasionally abbreviated to Anywhere.
The dialect of SQL supported by Enterprise is called Transact-SQL. In this chapter, the alternative dialect, supported by Anywhere, is called Watcom-SQL.
An overview of Transact-SQL support
Adaptive Server architectures
General guidelines for writing portable SQL
Configuring databases for Transact-SQL compatibility
Writing compatible SQL statements
Transact-SQL procedure language overview
Automatic translation of stored procedures
Returning result sets from Transact-SQL procedures
Variables in Transact-SQL procedures
Error handling in Transact-SQL procedures