I would like to use a SQL variable to check the count of rows in a table. Ideally I'd like to have the connection info configurations be dynamic. Can I use other variables to do this?
SQL variables are executed when the test is initializing. That means that they are run pretty early in the startup process. So you cannot use a variable in the SQL statement to make your call dynamic.
You could add a POST on our Idea application to raise an enhancement request on that area.