Zoomed Image

AMSX Scripting Language - Command : SqlInListValues

Summary

Store a list as a SQL-safe parameterised VALUES list for bulk INSERT statements

Description

Marks the value as a SQL insert-list type so that each item in the comma-separated input is converted to a parameterised placeholder such as (@var1),(@var2). Must be used with variable assignment. Throws if not assigned to a variable.

Parameters

ParameterDescription
cmdComma-separated values to convert to parameterised INSERT placeholders

Syntax


SqlInListValues "Comma-separated values to convert to parameterised INSERT placeholders"

Return to the AMSX Command Reference