The Command object is used to obtain records and create Recordset objects, as well as to execute bulk operations or manipulate the structure of a database. Depending on the functionality the provider exposes; some collections, methods, and properties of a Command object may not be available. Refer to your provider's documentation to verify a command feature is available before attempting to use one.
In previous chapters we have taken a look at how we use the Command object. Now let's take a closer look at one of its most appealing capabilities, especially when working with SQL Server.