A Command object is best used to make changes to data - INSERT, UPDATE, or DELETE SQL statements.
First, set some properties of the Command object:
ActiveConnection The connection object CommandText The SQL statement, a query name, or a table name CommandType The form that the CommandText is in.
Then Execute method of the Command object has the three optional parameters. The second one is the most useful, as it will return a number indicating how many rows were affected by the SQL statement.
myCommand.Execute , intRowsAffected
Response.Write "Number of rows affected: " & intRowsAffected
Creating a Command object:
ASP Dim objCmd
Set objCmd = Server.CreateObject("ADODB.Command")
VB Dim objCmd as ADODB.Command
Set objCmd = New ADODB.Command
VB .Net Dim objCmd as New ADODB.Command