I'm making good use of ADODB recordsets. The capabilities they offer are amazing.
I have some operations, however, where I don't really need all the capabilities of a recordset. A simple SQL statement will do the job just fine.
Are there any recommendation when to use recordsets vs. plain SQL?
Thanks for your help.