Comments
Sort by recent activity
Hi @sheldonhull,
This issue has been fixed in our latest release. We no longer convert to the alternate alias style when there is an OUTPUT clause.
You can download it here: http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_8.0.9.2226.exe
Thanks again for reporting.
Best,
Michael / comments
Hi @sheldonhull,
This issue has been fixed in our latest release. We no longer convert to the alternate alias style when there is an OUTPUT clause.
You can download it here:http://download.red-gate...
Hi Sheldon,
Thanks for the report, I've reproduced the problem with your submitted code. Here's a minimum example based on yours which exhibits the issue: update #temptest
set test_column = 1
output test_column_new = Inserted.test_column
Unfortunately the Microsoft Parser which we use for formatting does not support the equals alias syntax: https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql
In fact when I run the query on my local database, SSMS returns: Msg 102, Level 15, State 1, Line 8
Incorrect syntax near '='.
Are you able to run this query successfully, what version of SQL Server/SSMS are you using?
Best wishes,
Michael / comments
Hi Sheldon,
Thanks for the report, I've reproduced the problem with your submitted code. Here's a minimum example based on yours which exhibits the issue:update #temptest
set test_column = 1
output...
Hi Jon,
I've managed to reproduce your bug on my machine so we've logged a bug under reference SP-6429.
Thanks for reporting! We'll let you know if we find a fix.
Best,
Michael / comments
Hi Jon,
I've managed to reproduce your bug on my machine so we've logged a bug under reference SP-6429.
Thanks for reporting! We'll let you know if we find a fix.
Best,
Michael
Hi Torsten,
We have reproduced the issue and have logged it under reference SP-6428.
We will let you know when we have found a fix.
Thanks again for reporting.
Best,
Michael / comments
Hi Torsten,
We have reproduced the issue and have logged it under reference SP-6428.
We will let you know when we have found a fix.
Thanks again for reporting.
Best,
Michael
Hi Laura,
We have two versions of SQL Prompt, SQL Prompt Pro and SQL Prompt Core. SQL Prompt Core is installed when you install the Data Processing workload in Visual Studio 2017 Enterprise. Unfortunately you cannot use the free SQL Prompt Core license from Visual Studio Enterprise to use SQL Prompt Pro in SQL Server Management Studio.
If you want more advanced features like being able to use SQL Prompt in SQL Server Management Studio or advanced formatting, we would recommend that you purchase a license for SQL Prompt Pro.
There are more details about the two editions on this website: https://www.red-gate.com/products/sql-development/sql-prompt/entrypage/microsoft-and-sql-prompt
Hope that helps!
Best,
Michael / comments
Hi Laura,
We have two versions of SQL Prompt, SQL Prompt Pro and SQL Prompt Core. SQL Prompt Core is installed when you install the Data Processing workload in Visual Studio 2017 Enterprise. Unfort...
Hi IndyNotesGuy,
Do you have any experimental features like auto-refreshing turned on?
Would it be possible to tell us a little more about when the exceptions happen? Is it on startup?
Best wishes, / comments
Hi IndyNotesGuy,
Do you have any experimental features like auto-refreshing turned on?
Would it be possible to tell us a little more about when the exceptions happen? Is it on startup?
Best wishes,
Hi mhickin,
Thanks for the feedback, we want to understand what could be causing the slowdown.
Would it be possible to be specific at the precise moments where the slowness occurs?
e.g. is it when you accept the suggestion or when the suggestions list loads?
Best,
Michael / comments
Hi mhickin,
Thanks for the feedback, we want to understand what could be causing the slowdown.
Would it be possible to be specific at the precise moments where the slowness occurs?
e.g. is it when ...
Hi CMeese,
Sorry to hear you are also experiencing a slowdown. You can download 7.5.1.1000 directly here: http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_7.5.1.1000.exe
Best,
Michael / comments
Hi CMeese,
Sorry to hear you are also experiencing a slowdown. You can download 7.5.1.1000 directly here:http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_7.5.1.1000.exe
Best,
Michael
Hi dewet,
Would it be possible to tell us a little more about what features were slower and when you experienced the slowdown?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi dewet,
Would it be possible to tell us a little more about what features were slower and when you experienced the slowdown?
Best wishes,
Michael Clark
Technical Lead, SQL Prompt
Hi Diego,
Thanks for getting in touch.
SQL Prompt Core requires you to login to continue using it after 28 days. If you would prefer to use Native IntelliSense (comes with VS), press "Revert to IntelliSense" to get back to normal Microsoft IntelliSense.
SQL Prompt Core has a few advantages over Native IntelliSense. We have written about these on the Visual Studio Marketplace: https://marketplace.visualstudio.com/items?itemName=vs-publisher-306627.RedgateSQLPromptCore
Best wishes,
Michael Clark
Technical Lead, SQL Prompt / comments
Hi Diego,
Thanks for getting in touch.
SQL Prompt Core requires you to login to continue using it after 28 days. If you would prefer to use Native IntelliSense (comes with VS), press "Revert to Int...