Dynamic execution of Transact-SQL

Adaptive Server version 12.0 provides an extension to the execute command that enables users to define Transact-SQL commands dynamically at execution time. Applications and procedures can use the new execute() syntax in cases where table names, column names, and so forth are not known until the application or procedure executes.

For more information about this feature, see the execute pages in the Reference Manual.