Parameterize Query & Substitue Values

60 views
Skip to first unread message

Alfredo Giotti

unread,
Jan 14, 2016, 9:39:36 AM1/14/16
to SQLTest
Hello Gentlemen,

Please excuse my ignorance. Do you have any videos displaying how to use the two features listed in the subject line. I have read the online documentation and I am confused. 

Best Regards,

Ramesh Meyyappan

unread,
Jan 14, 2016, 12:04:05 PM1/14/16
to SQLTest
Hello Alfredo

We don't have videos explaining these features yet, but we have a step-by-step guide to get you started (both of these topics are listed under 'Examples on how to use SQLTest' in http://www.sqltest.org/Documentation)



What you need to know is there can be 2 connection strings (they can be same or different):
One under General Settings (under Menu -> Settings) that supplies the parameter/substitute values using stored procedure.
The other is part of the workload (main window) that uses the parameter/substitute values, the target server.

The column names returned from the stored procedure should be same as the parameter name.
The stored procedure can return different parameter/substitute values based on @Connection, @ConnectionString, @Thread, @BatchIndex, @CommandText. For example the same stored procedure can return different parameter values based on batch content (@CommandText).

Let me know if this step-by-step guide is helpful or needs some more explanation.
I will try to get a video made in the next possibility

Best Regards

Alfredo Giotti

unread,
Jan 14, 2016, 1:17:21 PM1/14/16
to SQLTest
Hello Ramesh,

Good to hear from you! Awesome tool you have here. We just purchased the full unlimited license.

I will give these examples a go at it and let you know if I need any further assistance.

Best regards

Ramesh Meyyappan

unread,
May 30, 2016, 1:20:41 AM5/30/16
to SQLTest
Hello Alfredo

Here is the link to the video with hands-on example that uses Parameterize Query & Substitute Values feature:

Let me know if you have additional questions.

Best Regards
Reply all
Reply to author
Forward
0 new messages