Zoomed Image

AMSX Scripting Language - Command : SqlStatement.TopRecords

Summary

Limit the number of rows returned by a SQL statement variable

Description

Sets the TOP predicate on the SQL statement variable so that at most the specified number of rows are returned. Set to 0 or omit to remove the limit.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0maximum number of records to return

Syntax


SqlStatement.TopRecords "SQL statement variable name", "maximum number of records to return"

Return to the AMSX Command Reference