This chapter explains how to use Transact-SQL 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. Since stored procedures are compiled and saved in the database, they execute quickly without being recompiled each time you invoke them.
