This is a regular task for us in our automation work.
What I do is use the ADO object (see https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html) to create connections and queries to our SQL database. The link provides some basic examples as to how to implement the objects. Your code may end up being more complex depending upon what you need to do.
I have an extension (see my signature for the link) that encapsulates some of this for easy of use. This code simply fires the queries. Doing the comparison is simply writing "if-then" logic to compare the result of the query with the expected values. The expected values, if dynamic, should still be attainable in your automation. You've created the data in the first place during the course of the automation so you should be able to construct the expected values in code.
Robert Martin
[Hall of Fame]Please consider giving a Kudo if I write good stuff
----
Why automate? I do automated testing because there's only so much a human being can do and remain healthy. Sleep is a requirement. So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.
Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
