Chapter 6: Using Transact-SQL Statements

This chapter explains how to use Transact-sequel statements with Embedded SQL and host variables. It also explains how to use stored procedures, which are collections of SQL statements stored in Adaptive Server. Because stored procedures are compiled and saved in the database, they execute quickly without being recompiled each time you invoke them.