Comments
Sort by recent activity
Hi @....strauss,
I think that refreshing suggestions is still working properly, probably you are in the same script where you've created and deleted something (tables, sps, etc.).
We add objects to suggestions when we detect a create statement of something.
We do it like this because otherwise, it would not be possible to give any suggestions in the script as in some sense it's still not invoked and we can't predict what is the real purpose of the user.
Best regards,
Krzysztof / comments
Hi @....strauss,
I think that refreshing suggestions is still working properly, probably you are in the same script where you've created and deleted something (tables, sps, etc.).
We add objects to...
Hi @torsten.strauss ,
We chatted on the team and we think that some people still want to have that suggestion, because they writing some bigger script and they don't go through one by one statement.
If you think that it is still valuable to change that behaviour would you mind put it on UserVoice.
Best regards
Krzysztof / comments
Hi @torsten.strauss ,
We chatted on the team and we think that some people still want to have that suggestion, because they writing some bigger script and they don't go through one by one statement...
Hi @....strauss,
Sorry for your inconvenience. I've reproduced the problem and I logged that task with ticket: SP-6775.
Best regards,
Krzysztof Kroczak / comments
Hi @....strauss,
Sorry for your inconvenience. I've reproduced the problem and I logged that task with ticket: SP-6775.
Best regards,
Krzysztof Kroczak
Hi @torsten.strauss
There's already described that idea on UserVoice:. Would it be possible to vote on that?
Unfortunately, we should admit that the process of reviewing UserVoice was outside the main flow of development. We thought about it and we plan to have special meetings in 2018 to take UserVoice into our consideration.
Best regards,
Krzysztof Kroczak / comments
Hi @torsten.strauss
There's already described that idea on UserVoice:. Would it be possible to vote on that?
Unfortunately, we should admit that the process of reviewing UserVoice was outside the m...
Hi @ggeier,
Sorry for your inconvenience. I've reported that under this ticket: SP-6732.
Best regards,
Krzysztof / comments
Hi @ggeier,
Sorry for your inconvenience. I've reported that under this ticket: SP-6732.
Best regards,
Krzysztof
@PDinCA sp_executesql is stored procedure which executes string as query
so your script should look like that:
EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = ''CountryName'';'
Now you shouldn't have the error. I agree that the error dialogue is not verbose and doesn't say what's wrong. We will work on that in near future.
If you would like to use some params in that sp you can do it like AlessandroAlpi mentioned above:
EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = ss;'
, @params = N'@p0 VARCHAR(100)'
, @p0 = 'USA';
Hope that helps / comments
@PDinCA sp_executesql is stored procedure which executes string as query
so your script should look like that:
EXECUTE sys.sp_executesql @stmt = N'SELECT * FROM dbo.Countries WHERE CountryName = ''...
Hi @PDinCA,
It is still possible to inline execute statement in your script. You can do it from the context menu (right mouse click "Inline EXEC") and the shortcut [CTRL+B, CTRL+I] is still available.
Do you have some issues with this shortcut?
Best regards,
Krzysztof / comments
Hi @PDinCA,
It is still possible to inline execute statement in your script. You can do it from the context menu (right mouse click "Inline EXEC") and the shortcut [CTRL+B, CTRL+I] is still availab...
Hi @emoreau,
Is it possible to present your idea on uservoice?
Best regards,
Krzysztof / comments
Hi @emoreau,
Is it possible to present your idea on uservoice?
Best regards,
Krzysztof
Hi @alphonseg,
Thanks for letting us know. We don't have enough information to answer.
Would it be possible for you to send us these scripts (either on the forums or by emailing it to us at sqlpromptteam@red-gate.com) that is not good in your opinion?
Best regards,
Krzysztof / comments
Hi @alphonseg,
Thanks for letting us know. We don't have enough information to answer.
Would it be possible for you to send us these scripts (either on the forums or by emailing it to us at sqlprom...
Hi WarrenL,
Sorry to hear about it. Unfortunately, I can't replicate the issue on my machine. Can you check your Prompt logs? Maybe they will explain the situation.
Best regards,
Krzysztof / comments
Hi WarrenL,
Sorry to hear about it. Unfortunately, I can't replicate the issue on my machine. Can you check your Prompt logs? Maybe they will explain the situation.
Best regards,
Krzysztof