SQL Output Format
The SQL output format uploads output records to a table in a SQL database.
This output format can upload records to a table in any ODBC-compliant database, including Microsoft SQL Server and Microsoft Access databases.
When the target table does not already exist in the specified database, the SQL output format creates a table with as many columns as the number of fields in the SELECT clause of the query. In this case, the SQL type of each column is determined by the data type of the corresponding output record field, as described in Column Type Mappings.
If the target table already exists, the number of columns in the table must match exactly the number of fields in the SELECT clause of the query, and the SQL type of each column must be compatible with the data type of the output record field in the same position, as described in Column Type Mappings.
Column Type Mappings
Into-Entity Syntax
Parameters
Examples