Use SQLCommand when the data source resides in a Microsoft SQL Server database and you want to perform update, insert, or delete commands on the database.
The SQLCommand requires SQL Server 7.0 or greater. The SQLCommand wraps .NET’s SQLConnection component. Note you cannot return data using this component.
The SQL Insert, Update, or Delete statement. Here is an example:
When you use a statement containing variables, input data ports will appear on the Execute connection block. Here is an example:
The string used to open the data source. To create the Connection String, browse this property to open the Connection String Editor window. Here is an example:
In this case the connection string entered was:
Once you have entered a connection string, click the Test button to verify the connection.
|Execute||The Execute method design block is displayed on the automation when you add the SQLCommand component. Trigger the method to execute the command.||As required by Command||Void|