Forum Discussion

herbie68nl's avatar
herbie68nl
Occasional Contributor
10 years ago
Solved

Can I push a set of lines to execute in SQL instead of line by line

I Use VB Script   I recorded a trace file using the SQL profiler. This gives me all "exec ...." (stored) procedures that are executed by my desktop application.   Now I want to reuse tose lines s...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    10 years ago

    Hi Herbie68nl,

     

    As far as I understand, you want to pass several SQL requests at once. This is impossible in ADO.

    You need to think on how to change your request so that it selects all data you need, but in one call.

     

     

TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
10 years ago

Hi Herbie68nl,

 

As far as I understand, you want to pass several SQL requests at once. This is impossible in ADO.

You need to think on how to change your request so that it selects all data you need, but in one call.

 

 

herbie68nl's avatar
herbie68nl
Occasional Contributor
10 years ago

Thank you Tanya for your answer.

 

I already thaougt about this. But cound find a way to do this. We want to simulate the load to SQL from our application, and therefore I need to do it this way. 

But 'Can't be done' is also an answer and maybe it is the most clear answer of all. We are arleady searching for other tools where we can do this kind of testing.