You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

You can create a new SAS, DB2, or other database management system table from your output; see Creating New Tables for details You can save the SQL query to a catalog entry of type SQL. You can save ...