Content Comparison

...

This activity selects and returns Row(s) from a SQL Server database table. The example below displays a classic select query: select all data from a given table.

Activity Parameters

The Select Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

• Distinct (combo box control)  (type: string): whether the returned values should be distinct or not.
• Fields (text box editor type) (type: string): the column headers that you want to be returned with the select command. If you enter more than one you should separate them with ','.
• Limit (text box editor type) (type: string): limit the number of results.
• Order By (text box editor type) (type: string): the column header that you want to result to be ordered by.
• Order by Direction (combo box control) (type: string): choose to order the resulted rows in ASC or DESC direction. It will be ignored if Order By is not set.
• Table (text box editor type) (type: string): the table name on which to run the select.
• WHERE (text box editor type) (type: string): the Where statement. For example: ID>2 where ID is a column header.

...