Zoomed Image

AMSX Scripting Language - Command : SqlStatement.InsertInto

Summary

Insert the results of a SQL statement variable into an existing table

Description

Executes the SQL statement variable as an INSERT INTO ... SELECT statement, appending rows into the specified existing table. Use this when you need to accumulate results across multiple queries into one table.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0destination table name to insert into

Syntax


SqlStatement.InsertInto "SQL statement variable name", "destination table name to insert into"

Return to the AMSX Command Reference