SQL Output Format Into-Entity Syntax

Log Parser

SQL Output Format Into-Entity Syntax

<into-entity> ::= <table_name>
The <into-entity> specified in queries using the SQL output format is the name of the table where the results are to be uploaded to.

If the specified table does not already exist, 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 specified 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.

Examples:

INTO ReportTable

© 2004 Microsoft Corporation. All rights reserved.