Description:
Executes MSSQL query against database. Query can be defined as parametrized query and parameters can be set within task configuration “Parameters”
Parameters:
General parameters are the same as all tasks in FRENDS, but following are task specific.
Connection String: (String) Valid MSSQL connection string.
Query: (String) Valid T-SQL query e.g. “SELECT * FROM mytable”
Parameters: (Object Array) Each object presents one parameter in query.
Key: (String) Key that is referenced in query e.g. “@id” (User define these explicitly)
Sql Type: (String) Any accepted SQL type e.g. “Int”.
Value: (String) Value that matches to SQL type defined e.g. 1
Result value Success and Fault: