10-12-2017 01:00 PM
Longer answer: There are many different ways of "skinning the cat". I prefer to use the various ADO methods and objects to create SQL query objects for executing my SQL tasks and jobs. So much so that I created a Script Extension which encapsulates my code so that it's always available to me.
If you don't want to use the extension, there are various examples in the TestComplete documentation that shows the basics.
However, if you want to use what I already wrote, follow the links in my signature block.