Execute SQL Query
This script will run an SQL query on the device.
Input Parameters
Use Local |
Boolean |
Yes |
Determines if a local instance of SQL server is to be used. |
Server |
String |
No |
Name of the server, this should be blank for the local server. |
Database |
String |
Yes |
The name of SQL instance, use (local) for local unnamed instance. |
Type |
String |
No |
TCP or Named Pipes. |
Pipe |
String |
No |
|
Use SQL Authentication |
Boolean |
No |
Determines whether or not to use SQL Authentication rather than
Windows authentication.
|
User Name |
String |
No |
Used for SQL Authentication, not required for windows credentials. |
Password |
String |
No |
The password for SQL Authentication, not used for windows credentials. |
SQL Query |
String |
Yes |
The SQL query to run on the specified database. |
Output Parameters
Result |
Number |
Returns a success value of zero or any value other than zero to indicate failure. |
Example Input Parameters
Use Local |
Boolean |
Yes |
Select this option to connect to the local server. |
Server |
String |
No |
<intentionally left blank> |
Database |
String |
Yes |
SQLdev |
Type |
String |
No |
TCP |
Pipe |
String |
No |
<intentionally left blank> |
Use SQL Authentication |
Boolean |
No |
Select this option to use SQL authentication. |
User Name |
String |
No |
<intentionally left blank> |
Password |
String |
No |
<intentionally left blank> |
SQL Query |
String |
Yes |
SELECT Company, Country FROM Customers WHERE Country <> 'USA' |
Output Delimiter |
String |
Yes |
Comma |