Comments
Sort by recent activity
Hello @Dave Pendleton
Thanks for reaching out and sorry that you're having trouble with SQL Prompt. I've managed to reproduce the error using your example so thank you for bringing this to our attention. I'm escalating this to our developers for further review. I'll get back to you with further instruction.
Kind regards,
Pete Ruiz
Redgate Support
/ comments
Hello @Dave Pendleton
Thanks for reaching out and sorry that you're having trouble with SQL Prompt. I've managed to reproduce the error using your example so thank you for bringing this to our att...
Hello @Dave Pendleton , Thanks for your patience on this issue. We've logged a bug report in our internal bug tracking system which can now be referenced by SP-7861. So sorry for any inconvenience. We will update you once we reach resolution.
Kind regards,
Pete Ruiz
/ comments
Hello @Dave Pendleton ,Thanks for your patience on this issue. We've logged a bug report in our internal bug tracking system which can now be referenced by SP-7861. So sorry for any inconvenience. ...
Hi @ahdung , Please do add it to our UserVoice forum which is monitored by our Product Managers.
https://redgate.uservoice.com/forums/94413-sql-prompt Cheers,
Pete Ruiz
/ comments
Hi @ahdung ,Please do add it to our UserVoice forum which is monitored by our Product Managers.
https://redgate.uservoice.com/forums/94413-sql-promptCheers,
Pete Ruiz
Hi @ahdung .
So sorry, I could've been more clear. There isn't currently a way to change the format in the 'Copy as IN clause.' What I was referring to previously is that after you use the 'Copy as IN clause' feature and paste the values in the query window, you could then use our custom formatting feature to then place the commas before the values.
I hope this helps. Please let me know if there are any further questions.
Kind regards,
Pete Ruiz
/ comments
Hi @ahdung .
So sorry, I could've been more clear. There isn't currently a way to change the format in the 'Copy as IN clause.' What I was referring to previously is that after you use the 'Copy a...
Hello @ahdung , Thanks for reaching out and sorry for the trouble with
SQL Prompt. You can do this with a custom formatting style. In SQL
Prompt>Formatting styles>Global>Lists please select the option
to Place commas before items. [image] Then in SQL Prompt>Formatting styles>Expressions>IN please select the option to Place subsequent values on new lines so that the values are treated as items in a list. [image] Save and set the custom formatting style as active and you should get a similar result to the one below after you format the SQL code: [image] Please
note that this only applies after you format the code and there isn't a
way to paste the code in this format. If you would like the ladder, I
would suggest adding this to our UserVoice forum: https://redgate.uservoice.com/forums/94413-sql-prompt I hope this helps. Please let me know if there are any further questions. Kind regards, Pete Ruiz
/ comments
Hello @ahdung ,Thanks for reaching out and sorry for the trouble with
SQL Prompt. You can do this with a custom formatting style. In SQL
Prompt>Formatting styles>Global>Lists please select the op...
Hello @JRiedemann , I've just tested this feature in
9.5.21.11921 using a simple CREATE TABLE script and it worked as
expected using the default options. There were no duplicate semicolons
inserted even when there were semicolons already in the script. Can you please
provide a sample script that reproduces the issue on your end? Also, are
you using the default SQL Prompt options as well as the default
formatting style? If not, can you please share your options so I can try and
reproduce this? I didn't see anything related in the release notes but
might be worth upgrading to 9.5.21.11921 just in case. SQL Prompt download link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.21.11921.exe Kind regards, Pete Ruiz / comments
Hello @JRiedemann ,I've just tested this feature in
9.5.21.11921 using a simple CREATE TABLE script and it worked as
expected using the default options. There were no duplicate semicolons
inser...
Hi @gvarol@corelogic.com The green underline is
from our SQL Code Analysis feature that is integrated with SQL Prompt.
These are static code analysis rules that are run on your queries which
can be useful in checking routines, such as functions and procedures,
for 'code smells' that require code itself to be analyzed. You can turn this feature off by unchecking Enable Code Analysis in the SQL Prompt menu. [image] You can also investigate this further by reviewing the list of code analysis issues and the rules which caused the code to be underlined. [image] If
you feel the analysis is incorrect or there is something wrong with the
feature, could you please provide more details for us to investigate? Here is the documentation for working with SQL Code Analysis: https://documentation.red-gate.com/sp/sql-code-analysis I hope this helps. Please let me know if there are any questions. Kind regards, Pete Ruiz Product Support / comments
Hi @gvarol@corelogic.com The green underline is
from our SQL Code Analysis feature that is integrated with SQL Prompt.
These are static code analysis rules that are run on your queries which
can...
Hello @tee
We've released a fix for SCA-2609 in the latest release of the SQL Change Automation extension for Visual Studio version 4.1.20006. Here is a link to the release notes with additional information: https://documentation.red-gate.com/sca/release-notes-and-other-versions/visual-studio-extension-release-notes/sql-change-automation-visual-studio-4-1-release-notes
Fixes:
SCA-2609
- Prevent being able to click the import and generate script button
multiple times and show a progress screen while the import is in
progress.
Please update the extension in Visual Studio and let us know if you have any questions.
Kind regards,
Pete Ruiz
/ comments
Hello @tee
We've released a fix for SCA-2609 in the latest release of the SQL Change Automation extension for Visual Studio version 4.1.20006.Here is a link to the release notes with additional in...
Hello @Monday ,
So sorry for the lack of communication on this issue. We have logged
an enhancement request for this which can be referenced by SCA-2609. As
of now, the issue has still not been resolved. As I mentioned in the
previous reply, I'm going to follow up with our developers to see if
there's any plans in the near future to fix this.
Again, so sorry for any inconvenience.
Kind regards,
Pete Ruiz / comments
Hello @Monday ,
So sorry for the lack of communication on this issue. We have logged
an enhancement request for this which can be referenced by SCA-2609. As
of now, the issue has still not been r...
Hello @tee,
Thanks for bringing this up. It looks like there's an enhancement
request for this which can be referenced by SCA-2609. I'll ask our
developers for an update on this but in the meantime, can you please add
this to our UserVoice forum which is monitored by our Product Managers?
SQL Prompt UserVoice:
https://redgate.uservoice.com/forums/94413-sql-prompt
Kind regards,
Pete Ruiz / comments
Hello @tee,
Thanks for bringing this up. It looks like there's an enhancement
request for this which can be referenced by SCA-2609. I'll ask our
developers for an update on this but in the meanti...