Support for set statistics io, time on;

ggeier2

Could SQLPrompt support the syntax for set statistics io, time on;?  When I code this SQL, I noticed it's not supported.

Dan_J

Hi @ggeier2

Just to advise that a fix for this will be included in the next release of SQL Prompt, which I am hopeful will be next week.

Dan_J

Hi @ggeier ,

Thanks for reaching out to us regarding this.

So that we can be reproduce this, would you mind providing some example syntax for this?

ggeier2

The SQL is: set statistics time, io on;

Dan_J

Hi @ggeier

Thanks for your last comment on this, my apology for the delay in coming back to you.

I have been discussing this with our development team, however we feel we need to clarify exactly what you mean when you say this syntax isn't supported?

From my own testing, I can see that suggestions cease to be given beyond 'set statistics time'. Is this what you mean?

ggeier2

Yes, that's correct. There are no more valid suggestions after typing "set statistics time". But also, there are incorrect suggestions, so I end up typing the wrong SQL unless I remember to hit "esc" to close out of SQL Prompt.

Dan_J

Hi @ggeier2

Thanks for your previous update on this, our development team are now looking into this. 

We will come back to you again as soon as we have an update for you.

ggeier2

Thank you!

Victoria W

Hi @ggeier

This fix has now been released. You can download the latest version here:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.2.26629.exe 

ggeier2

Awesome! This works perfectly. Thank you!