Content Comparison

...

The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

• Query (text box editor type) (type: string): the SQL query string. For example: "SELECT Name, Company FROM Names where ID>1 and ID<4 order by name ASC"
  
  
  
  
• Script (text box editor type) (type: string): the query content if a binding to a variable is used ($using). If set and if the $using:variable syntax is used, this parameter will take precedence over the Query parameter. For example, the $using:DemoString syntax will take the value stored in the DemoString variable and will execute it:
  
  Image Added
  
  

The Read Only Output variable are the possible output values that the activity will provide:

...