[SQL Server] Execute

This module is built to provide a quick method for executing a SQL command on a Microsoft SQL Server database. There are not very many parameters needed for this module, so we can jump right into outlining them in the following table.

Parameter I/O Description
DbConnection In The database connection string used to allow the module to connect directly to the desired SQL Server instance and database. Since this setting can have sensitive information, it is visually protected the same way as a password field is and you cannot see what value you are typing into this field. Either carefully type in your connection information or you can copy/paste in a well crafted connection string.
Command In The SQL statement or command that should be executed on the supplied connection.
TimeoutSeconds In The amount of time, in seconds, that the module will wait for the command to execute. The default is zero (0), which means it will wait indefinitely for the command to finish. If a value is specified and the SQL command does not finish in the allotted time, the module will indicate a failure in the execution log.
LogOutputLevel In Minimal: Normal output to the log.
Verbose: More detailed output is written to the log, suitable for debugging purposes.
Result Out The result code returned from the command. If the SQL command contains any update, insert, or delete statements, then this returns the number of rows affected by the query. For other types of commands, then the result will always just return a value of negative one (-1).